Understood Gord but she said that wasn't doing it for her. I agree it would
be unnecessary IF the directions were working for her, but unfortunately,
they weren't. I was giving her an alternative to try.
--
Thanks for your thoughts.
Sincerely,
Gary Brown


"Gord Dibben" wrote:

Gary

The instructions OP posted are correct for copying unique data to another
worksheet and were copied directly from Debra Dalgleish's site

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

Don't need anything other than a sheet with data and a sheet to copy filtered
results to.

So your advice to copy the entire database to a third sheet then deleting later
is just a bunch of unnecessary steps.


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 09:34:00 -0700, Gary Brown
wrote:

I think you have to perform the paste in the same worksheet.