Archive weekly data

oldham94l

Board Regular
Joined
Jul 14, 2002
Messages
136
hi

i need to save weekly data over the course of a year, there are at least 3 spreadsheets each week, they contain just data on sales, stock etc.

the main problem i have is i need to file them, so they can be accessed by other workbooks and also each week the data needs to be consolidated into tables and graphs

i have 2 ideas at the moment,

1.) there is 1 file which contains the current weeks data, this file name is always the same,, then the following week the data is transfered to a new workbook with the end of week date as the file name

2.) my other idea is to pre set all the links by creating 52 files for each week and then linking them to one workbook,
this will be more time consuming and will have to be done each year

does anyone one have any better ideas?
thanks
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
Do you want to use your weekly form as a template and perhaps add some code to transfer your totals to another sheet or book using a button to perform this operation ? I have code to do this for my Invoice forms and you could adapt it. You will have to address the problem of ensuring data is saved after entry. You would also need a macro to clear the sheet after transferring the data
Forgot to mention that you could take a look at the Template Wizard
This message was edited by royUK on 2002-10-12 06:19
 

oldham94l

Board Regular
Joined
Jul 14, 2002
Messages
136
the data is already created, it just needs to be accessed by other workbooks, which analyse the data
This message was edited by oldham94l on 2002-10-12 07:25
 

Forum statistics

Threads
1,143,615
Messages
5,719,721
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top