can I export just the autofiltered data into own sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy value in field and insert it into filter 2
How to filter rows data based on background color of individual cells 1
Extracting Data 2
Using Autofilter on Protected sheets 3
Macro Help 6
Enabling Autofilter and Sorting in a Protected Sheet 2
Pulling a specific email from cells and putting info in new row 4
autofilter with summary row 1

Back
Top