View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sondra Sondra is offline
external usenet poster
 
Posts: 12
Default HELP!!! Advanced Filtering to another Worksheet

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.