View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil330 Phil330 is offline
external usenet poster
 
Posts: 1
Default How do I merge or combine 2 excel worksheets by a common collumn?

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.