Archiving 4 weeks of data into Month folders
 

hey All, my first post.

I need to archive data in a spreadsheet every month, this is a workbook
that is referenced to 4 weeks (1 spreadsheet per week). Here is a more
detailed outline of what i have;

Every week a productivity sheet for each manager containing peoples
overall scores. This is done for each week. I have a monthly
productivity that references each week results for each manager and
then a column for a monthly overall average.

Currently all of the weekly files are kept in one folder (each manager
has own folder) so I can reference the links to each week, but the
problem being I have to keep changing the references when I need to
view data for another month and the folder will start getting full
rather quick due to the amount of weeks worth of data.



Is there a way of also referencing the data to the month for the
monthly sheet and to also archive one months worth of data in a folder
i.e. "June".

Help appreciated. Thank You.

M


--
mosh
------------------------------------------------------------------------
mosh's Profile: http://www.excelforum.com/member.php...o&userid=35539
View this thread: http://www.excelforum.com/showthread...hreadid=553023

Archiving 4 weeks of data into Month folders
 

The process could be automated if we can see the file structures please.

"mosh" wrote in message
...

hey All, my first post.

I need to archive data in a spreadsheet every month, this is a workbook
that is referenced to 4 weeks (1 spreadsheet per week). Here is a more
detailed outline of what i have;

Every week a productivity sheet for each manager containing peoples
overall scores. This is done for each week. I have a monthly
productivity that references each week results for each manager and
then a column for a monthly overall average.

Currently all of the weekly files are kept in one folder (each manager
has own folder) so I can reference the links to each week, but the
problem being I have to keep changing the references when I need to
view data for another month and the folder will start getting full
rather quick due to the amount of weeks worth of data.



Is there a way of also referencing the data to the month for the
monthly sheet and to also archive one months worth of data in a folder
i.e. "June".

Help appreciated. Thank You.

M


--
mosh
------------------------------------------------------------------------
mosh's Profile:
http://www.excelforum.com/member.php...o&userid=35539
View this thread: http://www.excelforum.com/showthread...hreadid=553023