1st sheet

[Tia]

Hi
I am working on a workbook with identical sheets formats for a project
costing what i need is a summary sheet that allows me to know the
total of working hours for each project and the total of working time
for each project by each employee
the workbook cotain 12 sheets each month one sheet is added in the
same format but with more projects the format is this way

A B
C D
1 Project Name Employee listing
2 George
John Pamela
3 United Tower 100
10 50
4 UK Bridge 0
150 20


Each month a new sheet with more projects to be added and more
employees sometimes

What i need is a summary sheet that calculates the total of worked
hours pr employee for each project in order to have the costing

Thank you in advance
Tia

 

[Bernie Deitrick]

Tia,

Don't do that. Use a single worksheet, and add another column where you enter a date for each item,
and then you can apply data filters, use the data as a source for a pivot table, report generation,
etc.. without the complexity, error sources, and headaches of multiple sheets. Using separate
sheets for items that really belong together with separate identifiers is the single biggest mistake
that you can make when designing a workbook.

HTH,
Bernie
MS Excel MVP

 

[Tia]

Tia,

Don't do that.  Use a single worksheet, and add another column where you enter a date for each item,
and then you can apply data filters, use the data as a source for a pivottable, report generation,
etc.. without the complexity, error sources, and headaches of multiple sheets.  Using separate
sheets for items that really belong together with separate identifiers isthe single biggest mistake
that you can make when designing a workbook.

HTH,
Bernie
MS Excel MVP










- Show quoted text -

You are right but the issue is that :
I have a monthly shared workbook .Ech employee has his own sheet with
days from 1 till 31 and the list of projects he makes the data entry
and i get the month summary in one sheet for all the employees and all
the projects what i do is that i copy it to yearly summary .what i am
doing now is manually linking the sheets to the summary
exp:
A B
1 Project Name Celine Chemaly

2 Castle House 335.00 "the formula that i use to have the total of
B2 is "
=+'01012008'!F12+'01022008'!F12+'01032008'!F12+'01042008'!
F12+'01052008'!F12
so each month i have to manually add the new sheet what i am looking
for is a way so they can be added automaticly each month the total and
th enew info

Is there is a way so i c an do it ?

Thx in advance

Tia

 

[Bernie Deitrick]

Tia,

Insert a blank sheet "First" before all the data sheets (and just after the summary sheet), and
another blank sheet "Last" after all the data sheets.

Then use a formula like this

=SUM(First:Last!F12)

to sum all the F12 cells on sheets located between First and Last.

And when you copy and insert data sheets, make sure that they end up between First and Last so that
they will be included in the SUM.

HTH,
Bernie
MS Excel MVP

You are right but the issue is that :
I have a monthly shared workbook .Ech employee has his own sheet with
days from 1 till 31 and the list of projects he makes the data entry
and i get the month summary in one sheet for all the employees and all
the projects what i do is that i copy it to yearly summary .what i am
doing now is manually linking the sheets to the summary
exp:
A B
1 Project Name Celine Chemaly

2 Castle House 335.00 "the formula that i use to have the total of
B2 is "
=+'01012008'!F12+'01022008'!F12+'01032008'!F12+'01042008'!
F12+'01052008'!F12
so each month i have to manually add the new sheet what i am looking
for is a way so they can be added automaticly each month the total and
th enew info

Is there is a way so i c an do it ?

Thx in advance

Tia