Hi,
I know very little about programming excel but would really like to get the file discussed in post #8 on this thread to work for me. I really only need to add additional columns A2 to M2 to be copied over and don't seem to know how to do it correctly. I was just planning on using this file with the embedded macro and then just editing the query to my link. I either get a bunch of replicate data piling up if I get all of the columns to copy or I just don't get all of the columns. Can anyone tell what I'm doing wrong? Is there a way to include as many columns rows as you want and delete duplicates in the archive?
Bookmarks