Macro to Create Worksheets from a List

[MarkReddell]

Hello Excel guru's!!! I need help in writing a macro to create a worksheet based on an entry in sheet named: Employee's. Within this sheet in Col. D4:d103 is a list of employee ID number. Upon an entry I need a sheet to be created with the employee ID number by copying the sheet named: Mater Sheet. Is this even possible??? Help Please!!!

 

[Trebor76]

Good evening Robert! Thanks for your interest & reply!!! The first macro creates a separate sheet for all employee's from the "Master Sheet" that then tracks the employee's scheduling, & Attendance Tracking!!! The 2nd macro just run macros from the data Validation drop Down Menu List!!! The two aren't related in any way! However, I need to have access to both codes, combinng them into one code!!! Thanks, Robert!!!

I'm still of the opinion that it's not the most efficient way to do it but My Aswer Is This has provided a great solution so all good.

 

[MarkReddell]

Thanks again gentleman!!! This code worx great!!! Thanks 4 patience!!!

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.
As you work with Excel you will always find there are 10 different ways to do everything.

Thanks again gentleman!!! This code worx great!!! Thanks 4 patience!!!

 

[MarkReddell]

Thank you Mr. MyAswer Is This!!! I'm ok on excel, not with VBA!!! Thanks again for your willingness to be of help to many who lack your knowledge!!!

 

[MarkReddell]

I forgot to thank you for ALL your help!!! Thank you very much!!!