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