Filling in another sheet with filtered data


B

Brian Ness

I am using Excel 2007. On wheet one is a large amount of text and numerical
data. I am using the filter function to narrow down the data. What I would
like to know is how to automatically fill in sheet two or three with the
filtered data only.
Thanks
 
Ad

Advertisements

E

Emece

Select the range you want to copy in the other sheets.
Home Tab -> Find and Select -> Go To Special.

Check "Only Visible Cells". Ctrl+C (Copy) the selected range, Ctrl+V (Paste)
in the sheets where you want to paste this data.

Hope it helps

Regards,
Emece.-
 
B

Brian Ness

That will allow me to copy and paste once but is there a way to do it so that
sheet 2 is always changing when I change my sort?
Thanks,
 
Ad

Advertisements


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

Top