Good day,
I have the following query...please see attached sheet:
Sample_A Sheet
Row 1: Headers
Row 2: Main data entry section
Row 3: Contains references to Row 2
* This row will be later protected.
The key cell is cell D1
When a number is entered in cell D1, say for example, 10
1) Cells A3 to D3 are first copied, and then,
2) These copied cells are then copied to Row 4 to Row 11
* Thus, are repeated so the the number of copied rows equal the value of D2 - less two rows.
Sample_B Sheet
Contains sample data and perceived output.
Thanks to all who may be of assistance.
Bookmarks