Hi
Im working on a workbook and i need a sheet to make the summary of all
other sheets
each month i move or copy a sheet such as 30/07/2008 with the total
project calculation for each employee and put it in a 2008 summary
sheet workbook the workbook is as follows are sheets have the same
form so mainly in my workbook i should have 12 sheets and 1 summary
sheet
what i need is an automatic calculation that allows me whenever i
insert a monthly sheet to sumarize the total hours each employee
worked on the projects
i was trying a code in VBE but it seems that im doing something wrong
C10= Project Name and drop down list all the projects
D10=code
E10= international or local
F10= employee name
G10=employee name
H10=employee name
I10=employee name
J10=employee name
K10=employee name
L10=employee name

Thank you in advance

Tia,
Here is what I suggest:
New workbook. There are usually three worksheets (Sheet 1, Sheet 2, Sheet3).
Double left click "Sheet 1" to Change to "Summary".
Double left click "Sheet 2" to change to "Blank".
Set up "Blank" with all the raw data (C10 Project name and drop down list...)
Double left click "Sheet 3" to change to "30/07/2008".
Select "Blank" sheet, highlight entire worksheet, edit, copy.
Select "30/07/2008", edit, paste.
Now the format in "30/07/2008" is exactly the way you want it.
On "Summary" page set up with the information you want from "30/07/2008".
On "Summary" in cell "C10" type "=" select "30/07/2008" and the appropriate
cell and select enter. In C10 on "Summary" it will look like
"=Sheet30/07/2008!C$10" and so on.
The next month, select the previous month "30/07/2008", and edit, insert
worksheet. Select "Blank" sheet, highlight entire worksheet, edit, copy.
Select "Sheet 1", edit, paste.
Double left click "Sheet 1" and change to desired "30/08/2008"
On "Summary" sheet, select the first line of data, edit copy and paste the
next line down.
Change the cells from "=Sheet30/07/2008!C$10" to "=Sheet30/08/2008!C$10"
for all cells copied.

At the bottom of "Summary" put in sum column totals. This way every time you
add info, it will automatically update with new totals.
hth
Dennis
"Tia" wrote:

Hi
Im working on a workbook and i need a sheet to make the summary of all
other sheets
each month i move or copy a sheet such as 30/07/2008 with the total
project calculation for each employee and put it in a 2008 summary
sheet workbook the workbook is as follows are sheets have the same
form so mainly in my workbook i should have 12 sheets and 1 summary
sheet
what i need is an automatic calculation that allows me whenever i
insert a monthly sheet to sumarize the total hours each employee
worked on the projects
i was trying a code in VBE but it seems that im doing something wrong
C10= Project Name and drop down list all the projects
D10=code
E10= international or local
F10= employee name
G10=employee name
H10=employee name
I10=employee name
J10=employee name
K10=employee name
L10=employee name

Thank you in advance

On Jul 25, 11:24*am, FloMM2 wrote:
Tia,
*Here is what I suggest:
New workbook. There are usually three worksheets (Sheet 1, Sheet 2, Sheet3).
Double left click "Sheet 1" to Change to "Summary".
Double left click "Sheet 2" to change to "Blank".
Set up "Blank" with all the raw data (C10 Project name and drop down list....)
Double left click "Sheet 3" to change to "30/07/2008".
Select "Blank" sheet, highlight entire worksheet, edit, copy.
Select *"30/07/2008", edit, paste.
Now the format in "30/07/2008" is exactly the way you want it.
On "Summary" page set up with the information you want from "30/07/2008".
On "Summary" in cell "C10" type "=" select "30/07/2008" and the appropriate
cell and select enter. In C10 on "Summary" it will look like
"=Sheet30/07/2008!C$10" and so on.
The next month, select the previous month "30/07/2008", and edit, insert
worksheet. Select "Blank" sheet, highlight entire worksheet, edit, copy.
Select *"Sheet 1", edit, paste.
Double left click "Sheet 1" and change to desired "30/08/2008"
On "Summary" sheet, select the first line of data, edit copy and paste the
next line down.
Change the cells from "=Sheet30/07/2008!C$10" to "=Sheet30/08/2008!C$10"
for all cells copied.

At the bottom of "Summary" put in sum column totals. This way every time you
add info, it will automatically update with new totals.
hth
Dennis



"Tia" wrote:
Hi
Im working on a workbook and i need a sheet to make the summary of all
other sheets
each month i move or copy a sheet such as 30/07/2008 with the total
project calculation for each employee and put it in a 2008 summary
sheet workbook the workbook is as follows are sheets have the same
form so mainly in my workbook i should have 12 sheets and 1 summary
sheet
what i need is an automatic calculation that allows me whenever i
insert a monthly sheet to sumarize the total hours each employee
worked on the projects
i was trying a code in VBE but it seems that im doing something wrong
C10= Project Name and drop down list all the projects
D10=code
E10= international or local
F10= employee name
G10=employee name
H10=employee name
I10=employee name
J10=employee name
K10=employee name
L10=employee name

Thank you in advance- Hide quoted text -

- Show quoted text -

yes you are right but the issue is that each month there is new list
of employees and new list of project to be added on the old list
isnt any easier way to automaticly take them to the summary sheet ?
and calculate ?


Tia