Hi
Trying to get my spreadsheet to create a number of rows with some prepopulated values in certain columns based on an input value of number of rows to create.
Example:
Cell B2 contains an input value between 1-9999.
When a value is entered the equivalent number of rows should be added, starting at row 4. Some of the column values in the row should be prepopulated with values.
It also needs to be dynamic so, if the value in B2 is changed, the number of rows pre populated is also changed.
Can anyone help?
TIA
Trying to get my spreadsheet to create a number of rows with some prepopulated values in certain columns based on an input value of number of rows to create.
Example:
Cell B2 contains an input value between 1-9999.
When a value is entered the equivalent number of rows should be added, starting at row 4. Some of the column values in the row should be prepopulated with values.
It also needs to be dynamic so, if the value in B2 is changed, the number of rows pre populated is also changed.
Can anyone help?
TIA