I have no idea where to start with this. I have 2 list of names one for managers and one for the employees under them. I need to automatically assign a ID or number value to each name "this is being ran within another macro" So that i can do a vlookup on column b of the managers list and return the assign numbers in a list of employees with duplicates
does anyone know how i can automatically assign a number value to the first list. the first cell of data is always blank so if there was a way to tell the macro to start assighing at the first non blank adjacent cell, i might be able to just manually add a 1 and copy down
Thanks
List of managers
Bob 1
Peter 2
Angela 3
Frank 4
Justin 5
Jennifer Bob
Brian Peter
David Bob
Natasha Frank
Jeff Angela
Maria Angela
Kevin Justin
Antoinette Frank
does anyone know how i can automatically assign a number value to the first list. the first cell of data is always blank so if there was a way to tell the macro to start assighing at the first non blank adjacent cell, i might be able to just manually add a 1 and copy down
Thanks
List of managers
Bob 1
Peter 2
Angela 3
Frank 4
Justin 5
Jennifer Bob
Brian Peter
David Bob
Natasha Frank
Jeff Angela
Maria Angela
Kevin Justin
Antoinette Frank