Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying range to variable number of rows
I have a number of worksheets (Sheets 1 to 4) with formulas in A2:J2.
These formulas need to be copied down to however many rows are populated in Column A of another Sheet called Data. So, if I import 140 rows of data into the Data sheet and run the macro the formulas in Sheets 1 to 4 get copied from row 2 down to row 140, if I import 200 rows the formulas get copied to row 200 etc. I'm struggling with this - probably because I'm using a variable (number of rows) in another sheet rather than the equivalent of a shift-end-down-right command. Any help would be much appreciated Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a variable range of data from one worksheet to another. | Excel Discussion (Misc queries) | |||
Macro for copying a value to a variable no. of rows | Excel Discussion (Misc queries) | |||
Copying RANGE of variable length | Excel Programming | |||
Copying a variable range | Excel Programming | |||
count number of rows (variable range) | Excel Programming |