Excel copy formulars problem

[ajdesigns]

I have produced a spreadsheet in Excel where I enter downtime figures for 6 machines for a paticular month, with a different worksheets representing each day.
Another woorksheet references each day and totals the monthly value.
If this is month Jan, how can I copy the monthly totaling worksheet to feb, march etc., so that it references and totals the feb, march daily entries and not the january.
Each month is a seperate spreadsheet, ie jan, feb, march.

 

[xlbo]

1st point - keep all your data together - it will be much easier in thee long run if you add ALL your data to ONE sheet and add a date or month reference to the row of data you are adding. Excel has many facilities for producing summary reports but a lot less for aggregating and combining seperate bits of data

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[Adnane]

Good point Goeff. then a simple Pivot Table will do the thing.

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[SkipVought]

ajdesigns,

Let me reinforce Geoff's suggestion.

One of the BIGGEST mistakes that spreadsheet users make is to segment similar data to various locations/sheets/workbooks etc. Most people who do not have a fundamental understanding of database concepts, make this mistake.

You will find that Excel has rich functionality including...

Filter
Sort
Subtotal
PivotTable Wizard
Chart Wizard

as well as many other database functions and table lookup functions that facilitate data analysis and reporting from a consolidated data source.

You have many Tek-Tips contributors in this forum, who can help you understand how to use this toolset to accomplish your objectives.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884