Hi Sondra

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

Maybe
http://www.rondebruin.nl/copy5.htm#existing


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sondra" wrote in message ...
I have a Master List and I have made 4 separate worksheets for each of the
criteria fields I need to access.

WksMaster
WksA=apples
WksB=bananas
WksC=grapes
WksD=unknown

I've been trying to use the Advanced Filter to copy from the WksMaster to
WksA all rows that contain "apples" in column A.

I can't get it to work.

Please help me with this feature it is trying to make me crazy.

Thanks.