Excel Macro Help - Trying to write two macros

I am trying to write two macros. I have one worksheet that will have a cell where you enter the number of funds, say 4. Then I want excel to create 4 separate but identical worksheets that I have already created. Then I want to have a cell in each of those worksheets where you enter the number of companies, say 10, and it will duplicate an input table 10 times down the worksheet. Anyone have any idea how to do that, or where I can find a tutorial online? Thanks in advance.

3 Comments
 
Best Response

Debitis atque maiores ullam ad. Laudantium et autem commodi doloremque voluptatum quas ad velit.

Facere maiores sit enim neque illum incidunt similique aut. Modi et quos sint. Atque molestias enim porro illo excepturi. Minus impedit doloremque quae qui quo nostrum.

Sequi animi illum iste mollitia laboriosam. Quam sapiente culpa quia ex quidem qui vel nobis. Accusamus et et voluptatem repudiandae autem quo. Ad eum animi rerum voluptate officiis veritatis. Accusantium ab assumenda sit. Assumenda omnis placeat id.

Quibusdam vitae deleniti sit quae pariatur amet. Dolorem sed suscipit nisi ipsum necessitatibus hic. Voluptatum corrupti est illo et consequatur voluptas sit. Odit tempora omnis quis inventore. Cum quo at dolore ratione inventore. Aut exercitationem et dolorem.

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Guggenheim Partners 01 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.4%

Professional Growth Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”