Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Setting up spreadsheet
I currently have a spreadsheet that tracks employee errors. I have employee
names accross the top in row 1 and a list of types of errors going down in collum A. I put how many errors they made of each type in each persons collum. I have each week on its own worksheet tab. I then have one more worksheet that gives me totals and averages taken from the previous weekly worksheets. This works great. I have only done this for one month. I now need to start with one for this month, which will have a new total/average sheet (I track each month seperatly). What would the best/easiest way to set this up be? Each worksheet is named for the week (Aug 8-Aug12, etc) so they will change each week. Is there anyway i can set this up so i am not having to redo all of the functions on the total's page each month? |
#2
|
|||
|
|||
nkidd Wrote: I currently have a spreadsheet that tracks employee errors. I have employee names accross the top in row 1 and a list of types of errors going down in collum A. I put how many errors they made of each type in each persons collum. I have each week on its own worksheet tab. I then have one more worksheet that gives me totals and averages taken from the previous weekly worksheets. This works great. I have only done this for one month. I now need to start with one for this month, which will have a new total/average sheet (I track each month seperatly). What would the best/easiest way to set this up be? Each worksheet is named for the week (Aug 8-Aug12, etc) so they will change each week. Is there anyway i can set this up so i am not having to redo all of the functions on the total's page each month? One way, rename the sheets names before starting the new month, thr formulas will change automaticly Another way is to name the sheets as week 1, week 2 etc. Ilan -- ilanr01 ------------------------------------------------------------------------ ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797 View this thread: http://www.excelforum.com/showthread...hreadid=401157 |
#3
|
|||
|
|||
Sounds rather Orwellian Take the spreadsheet you completed for last month and make a copy of it. Using the copy you might find things easier if you rename the tabs week1, week2 etc rather than specific dates since as far as I know there is no way to automate the naming of the tabs. I'd also set up your workbook with 6 sheets, five of them will cover all the weeks in a month with the last sheet as the summary sheet. Once you have set up a master workbook like this, save it with the name of the month and you can make copies of it for each of the months going forward. Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=428629 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Setting up a spreadsheet to calculate apportionment of service cha | Excel Worksheet Functions | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |