Babydum
Board Regular
- Joined
- Feb 24, 2005
- Messages
- 164
Hi,
i've searched the forum re finding duplicates across many sheets. Column B on each sheet contains customer reference numbers. I need a formula on each line in column A (or a macro to do this) that will return "Dup" if that reference number appears anywhere else on that sheet or in the workbook. "Dup" would need to occur on all instances where there is duplicate (e.g, if there are two occurences of "QWERTY01", both will show a "Dup")
Sheets are imported on a daily basis, so the workbook is growing. That's why I'm thinking maybe code would be better, so that I can run whenever I need to check.
Thanks for any advice
i've searched the forum re finding duplicates across many sheets. Column B on each sheet contains customer reference numbers. I need a formula on each line in column A (or a macro to do this) that will return "Dup" if that reference number appears anywhere else on that sheet or in the workbook. "Dup" would need to occur on all instances where there is duplicate (e.g, if there are two occurences of "QWERTY01", both will show a "Dup")
Sheets are imported on a daily basis, so the workbook is growing. That's why I'm thinking maybe code would be better, so that I can run whenever I need to check.
Thanks for any advice