"chris" wrote in message
...
Just use Data: Filter: Advanced Filter Then choose your destination and
unique records.

Chris,

This just gives me a reply of "you can only copy data to the active sheet".

What i have to do is take the list from "data" and add it (filtered) to
"look_up". I will then be looking at "data2", "data3" and "data4" and doing
the same with them but adding them below the values from "data" so I get a
continuous list from the 4 worksheets in a column. I will then filter that
list and write the definative list to "summary".

I'll actually be doing this with contract numbers at work (and not dog, cog
or bed) and then importing the total spend, estimate, budget and forecast
hours next to each contract to show any discrepencies that need to be
addressed. As some contracts are in the future i'll get contract numbers on
the "estimate" sheet that are not on the "spend" sheet. As new data is being
added on a monthly basis I don't want to miss anything so thought creating a
summary sheet via VB or a Macro pull out the information faster (and be a
lot less prone to mistakes).

Regards

Ric