I'm looking for similar type macro. I'm brand new on this.
Scenario: I have set o data with a unique set of data in column A, Also, same coloum A has multiple data set as well. A good example: Manager 1 has 10 employee( first name, last, Address, Phone …..) Manager 2-- the same. I would like to create a macro that can create every manager into their own worksheet or a workbook. I really need help as I have no Idea where to start.
Any help will be appreciated.