compare two sheets in excel

Amd / Sempron
February 12, 2009 at 04:13:22
Specs: Windows XP, 2000+,
I have two excel tables(lists of companies with contact details) that have the same structure.First column is company name, second column is adress etc... There are some companies that appear in both tables. I need to compare those lists and cut companies that appear in both lists and paste them in sheet3. Search should be done by company name (first column).

See More: compare two sheets in excel

Report •

February 12, 2009 at 12:52:53
...Dad Mode On...

Single step through the code I sent you in response to your very similiar question the other day.

Once you understand how it works, modify it to work across sheets.

Use the VBA help files by placing you cursor on a word in the code and pressing F1. By figuring it out on your own, you'll learn a whole lot more than if someone just supplies the code.

If you have specific questions about syntax, come on back and we'll see what we can do.

...Dad Mode Off...

Report •

February 12, 2009 at 13:02:56
Thing is I needed help fast. But, will try to use your code to figure it out.

Report •

April 17, 2009 at 02:20:55
I have 2 excell sheets of employees. In one sheet name, staff no , address is present. In another sheet name, staff no and contact nu is present. I want to add the contact number from 2nd sheet to First sheet. How can i do this exercise?
operating system is windows xp.
Thanking You all in advance.

Report •

Related Solutions

April 17, 2009 at 07:00:44
Please post your question in its own thread with a relevant Subject line.

Adding your question to an existing thread that addressed a different issue makes the archives harder to search.

You are not "comparing two sheets", you are pulling data drom one sheet into another.

Report •

Ask Question