Excel

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

Guest

Help! How can I filter rows of data via the contents of one of the columns
and then copy the output of the filter (ie rows of data whos value in the
filtering column are all the same) into another worksheet?

Thanks

Bob
 
Hi

Having applied the filter, there will only be a reduced number of
visible rows on the sheet.
Mark the whole block of visible rows, Copy then Paste to your new sheet.
Only the visible data will have been copied.
 
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

VBA to Filter on variable column 5
need help on either doing a loop and counting specific values orusing subtotal function 2
Copy/paste data across filtered rows 1
excel 2007 filter 3 text values at the same time from the same co. 1
How do I autosum a filtered column 1
Need help with "Function to do what auto-filter does" 3
Excel Macro for deleting Rows containing dates greater than "today" 0
Merged cells disturb autofilter indicator 2

Back
Top