I'd like to make a table in excel, 5 columns wide. I'd like the amount of rows to be based on a value in a seperate cell.

If possible, I would like to have if dynamic, so if the number in the cell changes, so do the amount of rows.

thanks a bunch