Excel 2010 - combining spreadsheets
October 28, 2013 4:16 PM Subscribe
How do I combine two Excel spreadsheets that have one common field? I know what I want the end result to be, but I don't know what the solution is called or how to get there.
posted by dtp to computers & internet (10 answers total) 2 users marked this as a favorite
Spreadsheet 1 contains sales id, customer name, products sold, etc. Spreadsheet 2 contains sales id and sales team name and position. The common field is sales id, but the number of products and sales teams varies for each sales id number. I'll need to combine these reports on a regular basis, so a solution that is quick and easy to duplicate would be very helpful. My skill level is just a bit past that of a beginner.