creating multiple files from a spreadsheet
I have a spreadsheet created from Project which lists all tasks, the
associated resources, hours etc. I need to take the spreadsheet and
generate a time sheet for each resource.
Is there a way to do this so the file names will contain the resource's
name? I can save it to the same drive and filename each time but the
resources could change (new resources added) week to week. So, I need a file
created for each resource listed in the spreadsheet. The new spreadsheets
would then have each task for each resource in its own spreadsheet.
--
Carol Summa
|