Comparing sales

Closed
Report
Posts
1
Registration date
Monday February 4, 2013
Status
Member
Last seen
February 4, 2013
-
Hello,

I have two separate Excel spreadsheets (e.g. 2011 sales & 2012 sales) with the following columns: Customer ID, Customer Name, Product #, Sales $, Sales Units, which I want to compare the customers unit purchases and sales $ from year to year.
How do I combine the spreadsheets so I can compare the data?