Insert Rows Based on Input Cell

Hello All!


This is my first time on Excel Forum and I am looking for some help here with VBA, as I am very new to it. I am trying to make a relatively simple excel spreadsheet for a theoretical stock portfolio.

What I need from all you brains is help to create a list of theoretical stocks based on the input number of stocks to be held in the portfolio. The number of stocks would be an input cell. So if I place '10' in the input cell I need 10 rows to be placed in the table, along with its respective formulas. If I placed '15' into the input cell I would need 15 Rows to be placed into the table.

It gets a little more intricate with the returns and stock classifications. If anyone could help it would be greatly appreciated. If needed I could always send the file :D

Does this help?

Please Login or Register  to view this content.

Thanks for the help. I almost seemed to get it to work, however, It only inserted rows in row A and not the adjacent rows in the table range. (Range A-F) I also need to get these cells to be numbered in a series, hence changing the formula.

Can you attach a sample showing what your layout would look like before the macro, and a result sheet after the macro? Please include the formula that you want to insert.