Filling in another sheet with filtered data

  • Thread starter Thread starter Brian Ness
  • Start date Start date
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
 
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.-
 
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,
 
Back
Top