Hello,
I have tried everything but cannot find a solution, I am really hoping someone can help with this. I am looking for a macro that will look for duplicates in the same row across all worksheets. Each worksheet has the same style as the one below, I just need a macro that will look in each row across all worksheets and highlight any cells if there is a duplicate value entered.
Incase this sounds confusing I will explain in more detail. The macro should look at row 3 across all sheets, highlight any duplicates found and then repeat this for each row with data in it until it finds an empty cell. For example, if Jane (row 3) puts the value "1" in Sheet 1 and in Sheet 2 then highlight the cells where the "1" is located and repeat this cycle until the row is empty.
Any help is GREATLY appreciated!!! Thank you so much!
I have tried everything but cannot find a solution, I am really hoping someone can help with this. I am looking for a macro that will look for duplicates in the same row across all worksheets. Each worksheet has the same style as the one below, I just need a macro that will look in each row across all worksheets and highlight any cells if there is a duplicate value entered.
Incase this sounds confusing I will explain in more detail. The macro should look at row 3 across all sheets, highlight any duplicates found and then repeat this for each row with data in it until it finds an empty cell. For example, if Jane (row 3) puts the value "1" in Sheet 1 and in Sheet 2 then highlight the cells where the "1" is located and repeat this cycle until the row is empty.
Any help is GREATLY appreciated!!! Thank you so much!
