Identifying Differences in Monthly Reports

Hi there! So this is a pretty complicated problem and I was wondering if I could get help here.

I get sales forecast schedules every month, but I need to identify the changes that were made from the previous month so I can focus on those items. Changes I need to be aware of include new amounts of items, new items added to the report, and items that were in the old report but were removed from this month's report. Normally, I go through the new report with the old one open and manually highlight lines of data that were changed. Obviously this takes a long time having over 500 lines of data.

My excel version is 2010, so I cannot use the built in spreadsheet comparison tool that comes with 2013, nor can I download third party applications because of IT settings on my work computer. I can download excel files though.

I want to be able to easily identify changes in data via highlighting lines of data, but any other way of indicating change is acceptable.

I'll include a small sample size of my data, with one June's report in one tab and July's in the other.

I'm probably missing vital information so feel free to ask. The sample data is attached.

Thank you!

Forum Help.xlsx

Hey, I know I'm pretty new here, so my solution may not be as trusted as the senior members, but here's a go at a solution for you.

Create a new macro and name it compare. Copy and paste this into the VBA editor screen. You'll have to resave your file as a macro enable document. Now, this code gave me an odd error on Excel 2013 but seemed to be okay on 2010. If it does throw you an error, just insert a blank row following the last row of data.

Please Login or Register  to view this content.

Mazzaropi,

What I mean by new amounts of items is that sometimes the values in the months columns and the grand total column change from the old report to the new report. I would like to be able to identify these as well.

I really like what you did with rules 2 and 3 though, and these should help a lot. Thanks!

drsadistic,

Thanks for the code, I tried running it and it returned an error. When I debugged, it highlighted this line:

ws2.Cells(i, c).Select

which is about 12 rows from the bottom. I don't know much vba. Thanks.

Just add an extra line under your last live of data. That will fix it.

Originally Posted by drsadistic

Just add an extra line under your last live of data. That will fix it.

Add an extra line under my data? What should this line contain? Or do you mean in the vba code?

Just a blank empty line with nothing in it.