Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can I export just the autofiltered data into own sheet?
Need help extracting data from worksheet. Have figured out how to get in 1
area with the filter, but dont know how to extract it all at once |
#2
|
|||
|
|||
Hi
once you have filtered click on the first cell and press control & shift & end this should highlight the data that you have displayed then choose edit / goto / special click visible cells only then choose edit / copy go to where you want to copy the data to and choose edit / paste -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "kst82276" wrote in message ... Need help extracting data from worksheet. Have figured out how to get in 1 area with the filter, but dont know how to extract it all at once |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Formatting data | Excel Discussion (Misc queries) | |||
How can I export Excel data to Quicken? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |