compare macro|VBA & Macros|Excel Forum|My Online Training Hub

Good afternoon

Can a macro be written to look at each separate Excel sheet and compare last month run list against this month run list? Any help would be much appreciated.

Compare

• any new store added (column A)
• stores that have dropped off (column A)
• quantities changes (column J, K, L)
• and highlight these changes

If the macro can un-highlighted all columns colors, then only highlighted those that are different on the compare, would be awesome.  I have seen one written where I must upload the two different spreadsheets, then run a compare, but have no idea how to write a macro to do this for me.

Thanks again

Amy