Doesn't make much sense Greg. Maybe you should try explaining again.
If you build a new 5 column web query, why are you copying over from the
last one.

Do you mean to copy A:E over to F:J as an archive, then refreshing the web
query so the new data is in A:E

columns(1).Resize(,5).copy
Range("F1").PasteSpecial xlValues

What constitutes a new entry - or what constitutes a match (opposite of a
new entry)? All five columns must match?



--
Regards,
Tom Ogilvy

"Greg" wrote in message
oups.com...
Hi
I have made a list with a web query.
It is made up of columns A,B,C,D and E.
I wish to update the web query every couple of days
and paste the new list into the next available columns F,G,H,I and J.
I understand how to find the next available column with a VB script,
which I have seen in other posts, but how to find and paste A into F, B
into G etc for the next 5?

I then wish to compare the two lists ie ABCDE and FGHIJ for new entries
and then paste them to a new sheet. The
=if(countif($B:$B,A1)=0,"Only in A","")seems to be only for comparing
two columns to each other. Can it be modified to check the first 5
columns to the next 5 columns.
Thanks
Greg