VBA tool to create template to spot and highlight differences between two spreadsheets

[chima13]

Hello,

I have a VBA problem that i need help with.

Scenario:
We constantly receive spreadsheets from third parties which we use to record various metrics. The problem is that these spreadsheets are supposed to have the same headings and format to fit our set template but do not. It takes time to compare what is received with our template and highlighting these to the sender to correct and resend.

Proposed solution:
I want to create a VBA tool that lets you paste the spreadsheet received into a tab and compare it to our template, highlight differences so that we can go back to the sender and indicate what needs to be changed. This will save hours if i can pull this off.

My visualization: Very open to suggestions for improvements on this

My proposed VBA tool will have three tabs, VBA buttons on first tab and separate tabs for our template and the other for the spreadsheet received from third party.

1. Tab 1 buttons- compare columns
2. Tab 2 our template (we have various) the idea being you paste in the one you want to compare
3. Tab 3 the received template

Tab 2 (our template) should highlight columns that are missing (different).

Is this possible? Is it too complicated? Please help.

 

[DanteAmor]

You could upload a copy of your files (template and 2 user files with highlight differences) to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[chima13]

Thanks Dante.
I will do that tomorrow.

Regards
Chima