Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells by name only to another worksheet....
At work we have productivity sheets, we put the times we do a certain task.
The same tasks are not always done in order but we have to put them in order of time. I want to link all the time totals for one task to another worksheet (recap sheet). I cannot figure this out since they change location daily. I want the task totals to add up on the other worksheet automatically. Ex: worksheet one taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total worksheet two totals added for taskA totals added for taskB totals added for taskC remember the task change daily. Thank you for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells by name only to another worksheet....
Hi!
Assume: .........A............B................C....... 1...taskA.....b-time.....e-time total 2...taskC.....b-time.....e-time total 3...taskB.....b-time.....e-time total 4...taskA.....b-time.....e-time total 5...taskC.....b-time.....e-time total 6...taskB.....b-time.....e-time total Sheet2: A1 = taskA A2 = taskB A3 = taskC Enter this formula in B1: =SUMIF(Sheet1!A$1:A$6,A1,Sheet1!C$1:C$6) Copy down as needed. Biff "Jkralick" wrote in message ... At work we have productivity sheets, we put the times we do a certain task. The same tasks are not always done in order but we have to put them in order of time. I want to link all the time totals for one task to another worksheet (recap sheet). I cannot figure this out since they change location daily. I want the task totals to add up on the other worksheet automatically. Ex: worksheet one taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total worksheet two totals added for taskA totals added for taskB totals added for taskC remember the task change daily. Thank you for any help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells by name only to another worksheet....
Thanks,
that helped alot, and it was easier then I thought "Biff" wrote: Hi! Assume: .........A............B................C....... 1...taskA.....b-time.....e-time total 2...taskC.....b-time.....e-time total 3...taskB.....b-time.....e-time total 4...taskA.....b-time.....e-time total 5...taskC.....b-time.....e-time total 6...taskB.....b-time.....e-time total Sheet2: A1 = taskA A2 = taskB A3 = taskC Enter this formula in B1: =SUMIF(Sheet1!A$1:A$6,A1,Sheet1!C$1:C$6) Copy down as needed. Biff "Jkralick" wrote in message ... At work we have productivity sheets, we put the times we do a certain task. The same tasks are not always done in order but we have to put them in order of time. I want to link all the time totals for one task to another worksheet (recap sheet). I cannot figure this out since they change location daily. I want the task totals to add up on the other worksheet automatically. Ex: worksheet one taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total worksheet two totals added for taskA totals added for taskB totals added for taskC remember the task change daily. Thank you for any help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cells by name only to another worksheet....
You're welcome!
Biff "Jkralick" wrote in message ... Thanks, that helped alot, and it was easier then I thought "Biff" wrote: Hi! Assume: .........A............B................C....... 1...taskA.....b-time.....e-time total 2...taskC.....b-time.....e-time total 3...taskB.....b-time.....e-time total 4...taskA.....b-time.....e-time total 5...taskC.....b-time.....e-time total 6...taskB.....b-time.....e-time total Sheet2: A1 = taskA A2 = taskB A3 = taskC Enter this formula in B1: =SUMIF(Sheet1!A$1:A$6,A1,Sheet1!C$1:C$6) Copy down as needed. Biff "Jkralick" wrote in message ... At work we have productivity sheets, we put the times we do a certain task. The same tasks are not always done in order but we have to put them in order of time. I want to link all the time totals for one task to another worksheet (recap sheet). I cannot figure this out since they change location daily. I want the task totals to add up on the other worksheet automatically. Ex: worksheet one taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total taskA b-time e-time total taskC b-time e-time total taskB b-time e-time total worksheet two totals added for taskA totals added for taskB totals added for taskC remember the task change daily. Thank you for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |