Help with Macros

[RECICT]

Hey All,

I'm quite new to writing macro's in excel and would like some help doing the following:

I have one workbook with two sheets in it and on both sheets I have Company Name's in column A and Addresses in Column B. Sheet1 has both Company name and addresses and Sheet2 only has company names.

Sheet1 is a pretty big list of companies so a simple copy and paste would take a very, very long time.

I need a Macro that will search through the company names and compare the two lists. When it finds a company that is in both lists (column A of Sheet1 and Sheet2) I would like it to copy the data from the Address column (column B) on Sheet1 and paste it in the address column (column B) in sheet2 BUT only if the address column in sheet2 is empty.

I'm not 100% sure this is even possible but thought I'd ask.

Thanks,
RECICT

[Bishonen]

Please Login or Register  to view this content.

Might be that I've overlooked some outcome. If any error appears or the desired result is not what you asked for, just let me know.

[RECICT]

Thanks for your quick response Bishomen.

The Macro worked perfectly thanks for your help it is much appreciated.

[zbor]

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.