Filtering

K

kc

Hi,
I want to make the results of using Excel filtering
feature from one spreadsheet to appear on the next
spreadsheet. The filtered results may reflect data from
different row number.

My intent is to make the results appearing second
spreadsheet and in continuous row number.
 
A

Andy B

kc

Filter the list. Then Edit>Go To>Special>visible cells. Then Copy, and Paste
where you like.

Andy
 

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

Help creating a search form in Access XP 0
Need Help with a VBA subroutine 0
Need Help with Macro Security 1
Excel does not accept text format! 0
Sorting and filtering text 0
use xlup and offset in a range of cells 1
Filtering data from a non-continuous list 3
Using Office Forms and dynamically updating the excel backend 0

Top