How do I merge or combine 2 excel worksheets by a common collumn?

G

Guest

In excel I have May's data of names and descriptions. I just received June's
data of names and descriptions. Some of the same names appear in both months
excel spreadsheets. How can I combine or merge May's and June's excel
spreadsheets into a yearly spreadsheet so that all names are listed but only
once? The description cell is a non numeric cell that may change month to
month. The latest months description should be in the yearly spreadsheet.
Thanks in advance for your help.
 
E

Excelenator

Phil,

Have a look at this file. I used a vlookup formula and some
conditional formatting to check the June data for new items. If the
item was found to be new the conditioinal formatting was applied to
highlight the new items. Also, you could sort the June data by the
column with the vlookup statement in it to copy and paste the new items
into your yearly summary.

5115


+-------------------------------------------------------------------+
|Filename: Compare.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5115 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine worksheets and populate fields 1
In Excel 07, how do I merge two sprdshts with a common column? 1
How can I combine 2 columns into 1, Excel? 2
How do I merge 2 excel spreadsheets containing some common info? 1
Can I do a mail merge into an excel file from another excel file 1
How can I separate a large spreadsheet into worksheets? 5
12 month total in Excel - by worksheet - need a formula 1
how do i combine excel worksheets 1

Top