Filling in another sheet with filtered data

[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

 

[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.-

 

[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,

 

[Gord Dibben]

You can achieve this only through VBA.

Ron de Bruin shows you how.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP