Excel troubles

[smwilson]

Hi guys,

I currently have 2 spreadsheets. Spreadsheet A has x amount of email addresses.

Spreadsheet B has x amount of email addresses including all of the addresses in Spreadsheet A. It also includes personal information about all of the emails.

I need to find all emails in Spreadsheet A in Spreadsheet B including there relevant data. but i cant seem to do it.

Its a simple task but the only way I can get it working is by using the Find feature in spreadsheet B and typing in the email and copying and pasting the relevant cells. This would be fine but there are several thousand emails in Spreadsheet A and many more in Spreadsheet B

Any help would be much appreciated

*******************************************************************************************************************************************************************
Sorry for creating two of the same threads I thought I was editing the title and I created a new thread. please delete this thread
actual thread can be found here http://www.excelforum.com/excel-gene...her-sheet.html
*******************************************************************************************************************************************************************

Kind Regards,
Sam

[6StringJazzer]

Hi, smwilson, and welcome to the forum. I am not a moderator but forum rules require thread titles that give a good description of the problem. This is so if someone searches for a similar problem in the future, they will find your thread, and hopefully an answer.

I will recommend you modify your title to be something like

Match email addresses on one sheet with email addresses on another sheet

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.