I have our duty roster of two weeks in excel, where about 35 peoples allocated for 10 locations with the shorten forms of their names. Can someone please help me to write a macro to gets the lists of duty location of each person under each name automatically as I run the macro on this roster? Is it possible?
Bookmarks