Hi there,
I have tried searching through but failing to find the exact issue I have. I have a list of names (around 300) and I need to create a new workbook for each one whereby the name is dropped into cell K3 of Hours per week sheet (the workbook is 2 sheets in total). I would then like it to save with the person's name. As there are cso many I am really hoping there is an easier way than manually but it is beyond my capabilities at this time.
many thank, in advance!
Kerrence
I have tried searching through but failing to find the exact issue I have. I have a list of names (around 300) and I need to create a new workbook for each one whereby the name is dropped into cell K3 of Hours per week sheet (the workbook is 2 sheets in total). I would then like it to save with the person's name. As there are cso many I am really hoping there is an easier way than manually but it is beyond my capabilities at this time.
many thank, in advance!

Kerrence