Compare Two Sheets and Highlight Differences
Budget: $30 – $250 USD
I have an excel sheet and need some expert help with VBA. The task is to have Excel compare data on sheet and highlight any data that does not match a separate linked table in a different workbook. The workbooks are not laid out exactly the same, and Excel would need to match fields in a row of data with another matching field in the other (separate) workbook.
Example attached. This is not the actual data or format but just an example. There are potentially thousands of lines of data.
There are several other enhancements I want to make to the same sheet but wanted to start with the easiest first to develop a relationship. I need ongoing support.
Example attached. This is not the actual data or format but just an example. There are potentially thousands of lines of data.
There are several other enhancements I want to make to the same sheet but wanted to start with the easiest first to develop a relationship. I need ongoing support.