VBA macro to check for match

Hi can anyone help please I have a workbook with a "controls" sheet then the sheets after the controls sheet all have data in them. I need a macro to check if the name in A1 matches exactly with a cell on row 3 on every sheet. Then if any don't match write the sheet and name that doesn't match on the controls sheet in columns A and B

Hi Roadhouse,

Here is a program that I think might do what you are asking.

Please Login or Register  to view this content.

Hope it helps,

Dan

dan that was brilliant thanks