compare data in 2 worksheets
 

I have two separate worksheets with similar data, Worksheet1 and Worksheet2.
Columns A - F in each worksheet contain data. Column A in Worksheet1 and
Column A in Worksheet2 contain an account number. How can I compare the
account numbers in the two worksheets so that if the account number is in
Worksheet1 but not Worksheet2 it will produce the word "no" in Column G in
Worksheet1?

compare data in 2 worksheets
 

Hi Josh,

maybe this tips could help you

http://www.j-walk.com/ss/excel/usertips/tip073.htm


http://www.cpearson.com/excel/whatsnew.htm
here on 14-Jun-2000 has a link to download a Compare.XLA Addin

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Josh" escreveu:

I have two separate worksheets with similar data, Worksheet1 and Worksheet2.
Columns A - F in each worksheet contain data. Column A in Worksheet1 and
Column A in Worksheet2 contain an account number. How can I compare the
account numbers in the two worksheets so that if the account number is in
Worksheet1 but not Worksheet2 it will produce the word "no" in Column G in
Worksheet1?