Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying Filtered Data
I am running a Macro which filters data into 4 separate workbooks. I then need to copy the filtered data into the one workbook but when I do this it is copying the full 65,000 rows. Is there something I can record in a Macro that will only copy down to the last cell with a value in it. The number of rows is going to change each time the macro runs so I can't select the filtered data by itself. thanks -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=381239 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Formula for copying data for every 8th cell | Setting up and Configuration of Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |