tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Bit stuck on this,
In Sheet1 Columns B18:BY5000 I have a list of estate agents.
In Column F in have the company name,
I want to make a list in Sheet2 of all the duplicate Company names in Sheet1 Column F
I want to be able to delete or edit this list after so ideally if it could remove the data from Sheet1 that its putting in sheet 2 even better.
I would do this manually but I've got 52 states to get through so I need a macro>
Thanks
Tony
Bit stuck on this,
In Sheet1 Columns B18:BY5000 I have a list of estate agents.
In Column F in have the company name,
I want to make a list in Sheet2 of all the duplicate Company names in Sheet1 Column F
I want to be able to delete or edit this list after so ideally if it could remove the data from Sheet1 that its putting in sheet 2 even better.
I would do this manually but I've got 52 states to get through so I need a macro>
Thanks
Tony