creating multiple files from a spreadsheet

C

Carol Summa

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.
 
P

Pank Mehta

Carol,

I asked the same question some time ago and was point to the following:-

You may be able to use Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Or you could steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
 
Top