I have data coming to me as a CSV file from time to time. I can turn that into an Excel Workbook file easily enough, but here's the problem. I'm faced with a mass of numbers. Much of it remains unchanged from week to week, but therre's a lot of data and it's easy to overlook something. What I need is a way to have changes from last week's data indicated or highlighted in some way. Suggestions would be appreciated.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
HOW TO INDICATE CHANGES?
0
Answers
0
Selected Answer
There are many ways. The most suitable depends upon how your data are arranged.
- If they are on different worksheets - or even in different workbooks - a solution without VBA is difficult to imagine.
- If they are in different columns of the same worksheet - a state which can be induced manually or using VBA - a filter might be applied which filters out all that are equal, leaving those that are not.
- Or conditional formatting might be applied to one of the columns or both , highlighting those that are different.
- In fact, that should also be possible if the columns aren't on the same tab but would probably fail if compaison is attempted with another workbook.
Filtering and comparing will only work if the rows and their sequence are identical in both reports. If rows are periodically added or omitted the task becomes much more difficult, though perhaps not impossible, which makes VBA again more inviting.