I have account numbers in Col E on sheet1. i would like a macro to extract all duplicate account numbers in Col E and well as the row number on Sheet "duplicate"
Your assistance in this regard is most appreciated
See example of account numbers
Your assistance in this regard is most appreciated
See example of account numbers
| Excel Workbook | |||
|---|---|---|---|
| E | |||
| 1160 | 3200 | ||
| 1161 | 3200D | ||
| 1162 | 3200K | ||
| 1163 | 3200X | ||
| 1164 | 4200 | ||
| 1165 | 4200A | ||
| 1166 | |||
| 1167 | 3541 | ||
| 1168 | 4541 | ||
| 1169 | 3041 | ||
| 1170 | 4041 | ||
| 1171 | 3141 | ||
| 1172 | 4141 | ||
| 1173 | |||
| 1174 | 3999 | ||
| 1175 | 4999 | ||
| 1176 | 3999F | ||
| 1177 | 4999F | ||
Sheet1 | |||
