PDA

View Full Version : [SOLVED] Use one cell to create a variable number of rows on a different sheet



daustin
03-06-2015, 11:49 AM
I'm not even sure if this is possible. Trying to make a 'checklist' for projects at work.

Here is what I need:
The user enters a numerical value in a specific cell on the a sheet. On another sheet, creat that number of rows with 4 columns. One column is a number increasing by 1 each row the other three are blank but will need drop down boxes for the user to select an item.


Any help would be appreciated.

Thank you in advance.

GarysStudent
03-08-2015, 09:03 AM
Here is an example that you can adapt to your purposes. Enter a value in cell C3 and push the button:

daustin
03-17-2015, 08:02 AM
Yes, this worked great. Thank you.