You don't have to do anything to sheet1 or sheet 2. You copy sheet1 to
create sheet3, then do the work there.

--
Regards,
Tom Ogilvy

"yalex " wrote in message
...
Thanks for the help. I'm trying to not have to copy, paste, or delete
anything from Sheet 1 or Sheet 2 due to the fact that I would like to
be able to import other data into those two sheets and have it
automatically pulled into Sheet 3 and put into their respective
locations to be compared. If there is another way to do it without
having to move any of the data in sheet 1 and 2 then I would love to
know how to do it. Much appreciated.

yalex


---
Message posted from http://www.ExcelForum.com/