Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying only cells in a filter with data
Hi, if I filter a worksheet based on the data in one column, how do I use a macro to copy data in other columns (and the filtered column) into another worksheet? I only want the data which has been filtered, not blank cells below the filter. Then the macro would need to copy the detail from some other columns and paste the data alongside the filtered data in the new sheet. What code, stops the process at the end of the filtered data and then moves to the next step of the macro? Also it would need to copy the same amount of rows for each column so the data remains intact. Hope I have made some sense. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |