JimS
03-08-2010, 01:35 PM
Does anyone have some code that will copy an entire row down x number of rows where x is determined by the last row on a different worksheet?
In example, Sheet1 – Row 10 has several formulas across several columns that needs to be copied down the same number of rows that contain data on Sheet2. The data on Sheet2 starts in Row 2 (row 1 is a header row on Sheet2). The data on Sheet2 will vary in length each time this macro would need to run.
Thanks for any help…
JimS
In example, Sheet1 – Row 10 has several formulas across several columns that needs to be copied down the same number of rows that contain data on Sheet2. The data on Sheet2 starts in Row 2 (row 1 is a header row on Sheet2). The data on Sheet2 will vary in length each time this macro would need to run.
Thanks for any help…
JimS