Give the Debra Dalgleish website a try...
http://www.contextures.on.ca/xladvfi...html#ExtractWs
"Extract Data to Another Sheet"
--
Jim Cone
Portland, Oregon USA




"Chrissy"
wrote in message
I am trying to figure out how to extract table data using advance filter to
another location but im totally lost. Please help have looked at examples but
still can not get it...