Thread: Merge rows from 2 XLS files using a common key field.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gene Gene is offline
external usenet poster
  
Posts: 100
Default Merge rows from 2 XLS files using a common key field.
I have 2 Excel files with customer records. Each file has a common customer
number and the other fields are different. I would like to combine the data
into one file by using the common customer number to link the related records
from the 2 spreadsheets.
Reply With QuoteReply With Quote