LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add data based on a common field TracySLPS Excel Worksheet Functions 1 December 14th 07 04:04 PM
merge worksheets which share a common column? Neha Excel Worksheet Functions 1 February 20th 07 02:50 PM
How do I merge or combine 2 excel worksheets by a common collumn? Phil330 Excel Worksheet Functions 1 July 27th 06 04:22 PM
How do I merge 2 excel spreadsheets containing some common info? SOS Excel Worksheet Functions 1 November 7th 05 05:02 AM
Excel: how to merge data from 2 workbooks with 1 col. in common? Cesare Excel Discussion (Misc queries) 2 June 24th 05 11:14 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"