Comparing Maco

[mjheath]

Howdy, I was wondering if anyone could give me a hand with this excel problem i have. Im trying to make it so that within a workbook with multiple sheets, I can compare the data in one cell to that in the same cell within another sheet and flag them if they are the same. For instance, if cell A1 is equal to 5 in sheet 1, A1 is equal to 6 in sheet 2, and A1 is equal to 5 in sheet 3 i'd like to make a macro that will flag cell A1 (highlight it green for instance) in both sheet 1 and 3 to denote duplicates. I've spent a considerable amount of time pickin my brain on this one as im not good with macros or programming for that matter... can someone help me? Thanks!

[mjheath]

Anyone please?

[MickG]

Hi Mjheath,
This code does what you want, but instead of colouring the same cells it shows a Msgbox telling you which sheet are the same.
I can colour the cells if you want but it means you would have to manually remove the colours when you had finished, or write a bit of code to do it.
When you run the code an input box appears.
Click the cell with the chosen value Click "OK" msgbox appears.
Place the code in a Macro or Command Button on sheet (1)
Let me now if you have a problem

Please Login or Register  to view this content.

Regards Mick