create a summary sheet
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 |
create a summary sheet
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 |
create a summary sheet
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 |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com