Hi
I have a list of code eg. AH100, AH200 etc. in a column on a worksheet with
a field name 'StaffIDNo'. I would like to create a workbook for each code,
with the code in a specified cell e.g AH100, and the workbook named 'code'
Time allocation schedule.xls e.g AH100 Time allocation schedule.xls and
saved to the same specified folder.

Thanks.