| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter, Copy to another location
Hi,
Once filtered, select all the data, then do CTRL G, Special, visible cell only, OK, then CTRL C, then paste it where you need the information. if this helps please click yes, thanks "Tina" wrote: When I filter the data and copy to another location, ALL the data is displayed, not just the filtered data |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter to another location | Excel Worksheet Functions | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
