My name isXXXXX and Techie Ben asked me to assist you with this question
Reviewing the file.. One moment please...
Ok in order to generate that list a macro will be required. Would that be ok?
Ok, give me 30 to 45 mins to write and test the macro.
Will get back to as soon as I'm done
Ok here you go
To run the macro click the Go! button on the first sheet at the top. You can have as many names and rows on sheet 1 and the macro will process them all
Please note that since there is a macro in the file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button.
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution