auto filter data from shee1 to sheet2

[Michael Brown7]

I want data to be auto filtered from shee1 to sheet2 without having to
manually copy row by row to another sheet. Can this be done using functions?
Help is desperately needed.

 

[Ron de Bruin]

Hi Michael

You must use VBA if you want this or use my new Add-in.
I will release it soon.

manually copy row by row to another sheet

you don't have to do it one by one

Select you data
Press F5 .. Special
Check visible cells only
Ctrl-C ( to copy)
Go to the other sheet
Ctrl-V ( to paste)

 

[Gord Dibben]

Michael

You can autofilter then F5>Special>Visble cells only>OK

Copy selected rows to a new worksheet.

You could use Advanced Filter to another worksheet.

See Debra Dalgleish's site...

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs

Some of the work being done is manual, but not manually row-by-row.

Gord Dibben Excel MVP

On Tue, 21 Sep 2004 07:43:02 -0700, "Michael Brown7" <Michael