February 11, 2015
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.
- 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.