Comparison Macro

**LJ Joseph** · 05-22-2017, 05:50 AM

Hi All,

Bit of an odd Marco creation request for some of the users I support:
I need to build a Macro that can compare values on two different excel spreadsheets/tabs and note if they differ.
The spreadsheet data would be downloaded in CSV from a software platform, and the users should be able to put the sheets together in one open Excel book, click a button and it goes through and highlights changes from one sheet to the next one, see example of desired result; sheet 1 contains information from an export from 1 day, then sheet 2 an export from a later date, then the macro should be able to be activated then outline which values differ, on a unique ID basis.

Psuedo:
If
ID sheet 1 matches ID sheet 2
then
Compare row and highlight where differing values are.

It does not need to be exactly like this, very open to other ideas but I need to be able to compile it in a button on their tool bar

**arlu1201** · 05-22-2017, 05:53 AM

Hello LJ Joseph,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

**Doc.AElstein** · 05-22-2017, 01:33 PM

Hi LJ Joseph,

Welcome to Excel Forum

This is just the Sub Forum to say hello

What you would / should normally do if you have a question or need help is the following:
Start here, https://www.excelforum.com/ , then look for an appropriate Sub Forum to post your question in:
start a new Thread in one of these sub forums if you need help:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/

_.....................

Your requirements sounds quite easy in the face of it, and there are probably lots of ways to do it.
This is a very simple code_.......

Please Login or Register  to view this content.

_......... which assumes the ranges used are identical in both Sheet1 and Sheet2.
It goes through each cell in the used range rectangular area in sheet1, and compares the value in it with the value in the corresponding cell in Sheet2. If the values are not the same, then the cells in both sheets are highlighted in yellow. Rather than , or in addition to, highlighting those cells, a code could be written to do just about anything , such as build that list you showed

But think it would help a lot if you give us a small amount of mock up data. Keep it representative but not necessary real data.
Show us
_ 1. the start situation. The “Before”
_ 2. Give us an “After”. This “After” should be hand made by you to look exactly as you what the macro to produce for you based on your “Before”

From your description it looks to me as though your attached File is partially your “After”
It might be all of it. It is not totally clear. In any case it is a great help to see the data from which those results come from – the “Before”

So get that info together and post your question in one of the main Forums – I expect the “ Excel Programming / VBA / Macros “ (http://www.excelforum.com/excel-programming-vba-macros/) , would be the one you want.

_............................................

Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/developmen...ml#post4606484
It is usually worth it in the long run.

Thanks
Alan

Comparison Macro

LinkBack

Thread Tools

Rate This Thread

Display