Compare Spreadsheets

[westie1871]

Hi Folks,

i have 2 spreadsheets which are from 2 places but both have a field that says References and Cost i want to compare the 2 spreadsheets on the Reference field and highlight the difference in price if there is one? if not highlight just display the different cost?

i would be greatful if someone could help me as ive been trying to sort this for ages!

thanks in advance

J

 

[VoG]

Maybe this http://download.cnet.com/Excel-Overlay/3000-2077_4-10963782.html

 

[westie1871]

hi that doesnt work as it doesnt have the same amount of columns any other suggestions?

thanks J

 

[westie1871]

Hi All,
i have enclosed examples hopefully someone can help

http://www.sharefile.org/showfile-4183/test1.xls
http://www.sharefile.org/showfile-4184/test2.xls

i need to compare test 2 with test 1 and show the differences on test1 on cost if possible

thanks all
J

 

[brettdj]

WOT didn't like sharefile so I haven't looked at the files

But if you need to compare differences between sheets that need row and column alignment then SpreadSheet Advantage offers you a 30 day free trial
- use the Row and Column Aligner tool to set the two sheets up
- use the Compare tool to report on differences (by value, formulae or both)

http://www.spreadsheetadvantage.com/

Regards

Dave