i am copying a dynamic range of cells from twelve different worksheets.
i need to select a range that starts of g10 on every sheet, but ends
differently on every sheet. the range ends depending on column A in the
last row of each range, the word 'total'. i would like to select the
range in column g10 down to the cell corresponding with 'total' in
column a in column g. For example, if there is 'total' is in a56, i
want to select and copy g10-g56. If on another sheet 'total' is in a68,
i want to select and copy g10-g68. there is information below the range.
i want to ignore the data below altogther. here is the code that i have
now for the first sheet. it grabs G10 through the last cell in column
g. any help would be appreciated. thanks.


Code:
--------------------
Sheets("January 2005").Select
Range(Range("G10"), Cells(Rows.Count, Columns("G").Column).End(xlUp)) _
Copy Worksheets("SALES REPORT").Range("a2")
--------------------


--
xcelelder
------------------------------------------------------------------------
xcelelder's Profile: http://www.excelforum.com/member.php...o&userid=27637
View this thread: http://www.excelforum.com/showthread...hreadid=471553