Compare 2 workbooks

[CHECKEMAIL]

Welcome, i have searched long and hard for a solution but nothing seemsto work the way i need

Hi have to make a macro to compare 2 seperate work books with multiple work sheets in

Basically i get a new report every week and i need to see what has changed because these sheets are 900+ rows long normally

Also new rows can be added or taken away so i want it to highlight only new info that has been entered or changed

P.S
i did have one Macro that highlighted the changes but it was only 1 sheet per workbook and i you had to put the exact name of the workbooks

I also found another that worked for selecting the workbooks but it was highlighting loads of data because if someone added a new row, it thought that all the rows below it were new because the cell data had phisically changed, i have uploaded the txt of this macro because its not too far off

Many thanks for your help in advance, i am desperate to find a solution

[AlphaFrog]

Have you considered using the Track Changes feature in Excel? This has to be turned on before the changes are made. If you do a web search for something like Excel Track Changes, you'll find several Guides\Tutorials\Videos.

Track Changes Video

[CHECKEMAIL]

Have you considered using the Track Changes feature in Excel? This has to be turned on before the changes are made. If you do a web search for something like Excel Track Changes, you'll find several Guides\Tutorials\Videos.

Track Changes Video

thanks i will take a look at this