No problem rogcar.

To get this running in your worksheet do the following.

Until you are comfortable using the VBA editor you should only have the 1 workbook open.

1. Open your workbook
2. Press ALT + F11 to open the visual basic editor
3. Go to Insert, Module
4. In that Module paste the code in there.
5. Close the VBA editor
6. Go to your worksheet and make any autoshape.
7. Right click on the auto shape and click on assign macro
8. Select the macro and press OK.
9. SAVE YOUR WORKBOOK and make a backup before you click on this shape now.
10. Click the shape and let the code run a new worksheet will automatically be created which you can go and freeze the top row after the code runs so you can search out your duplicates (There were only 2 the last time I ran it).
11. Post back here with your results and any questions.

Thanks