Filtering

  • Thread starter Thread starter kc
  • Start date Start date
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.
 
kc

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

Andy
 
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

Dynamic Filtering 2
formula results in the status bar 3
Autofilter header row 3
Excel 2003 1
Filter, Copy and Paste 2
Subtotal data excluding negitive numbers. 3
questions on advanced filter 4
SUBTOTAL 2

Back
Top