Compare Excel worksheets 2010

[ttooley]

OK. I know this may have been covered in another post but here is what I've got. I generated two reports from my system that have results for year 2010 and YTD 2011. The columns are all the same. I want to combine the two worksheets to show comparison between the two years. The two criteria to break down the results are Name and Product. There will be many of these that are common between the two worksheets so I just want to combine those and show the 2010 to 2011 comparison. And I want any unique Name/Products listed also where there might only be that Name/Product in either only 2010 or 2011. I have attached a sample. Thanks in advance for any help!

 

[scotty718]

This is pretty easy. All you need to do is copy the data from 1 sheet to another and make a pivot table on the data. You can probably use the wizard to figure out how to set up the table up to display what you are after... but if you need help, do a simple google search to understand pivot tables better.... If you are still stuck, please reach out to me

 

[Zack Barresse]

Hi there, welcome to the board!

This could be an application where to use PowerPivot - a free 2010 download.

HTH