Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying dynamic range based on cell outside of range
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range based on another column | Setting up and Configuration of Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Selecting and copying a dynamic range of cells | Excel Programming | |||
VBA: copying and inserting a dynamic range | Excel Programming | |||
Copying block (range of cells) based on a value of a specific cell-VBA | Excel Programming |