HI
This answer is probably somewhere in this forum, maybe not wording it
correctly.
What I have is 2 worksheets with names and various different information on
each.
eg
Sheet 1
Name CreditCard
Sheet 2
Name Address etc

What I want to do is compare the worksheets and if the name is on both
sheets to put a credit card in a new cell on sheet 2.
Thanking you