Hi everyone!

This is my first post in ozgrid.com, I sincerely hope that you may help to me with a Excel macro.

I have a Excel file with several worksheets, all of them have the same format.

Each cell contains a number with 7 figures. Each number is a traceability / tracking number, therefore each one should be different to the rest.

My doubt: is it possible to make a Excel macro capable of checking

I have found some macros that try to solve this situation but most of whom only check numbers in the same worksheet.

Thanks in advance.

P.S. By the way, sorry for my english I am trying to improve it, so if you see any mistakes you can send me a private message with your corrections, I appreciate you.

This is my first post in ozgrid.com, I sincerely hope that you may help to me with a Excel macro.

I have a Excel file with several worksheets, all of them have the same format.

Each cell contains a number with 7 figures. Each number is a traceability / tracking number, therefore each one should be different to the rest.

My doubt: is it possible to make a Excel macro capable of checking

**all numbers**in**all worksheets**and detect / notice repeated numbers?.I have found some macros that try to solve this situation but most of whom only check numbers in the same worksheet.

Thanks in advance.

P.S. By the way, sorry for my english I am trying to improve it, so if you see any mistakes you can send me a private message with your corrections, I appreciate you.

## Comment