View Single Post
  #1   Report Post  
Carol Summa
 
Posts: n/a
Default 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