| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I accrue certain cell values across multiple worksheets?
I have numerous payroll worksheets for an employee and want to show the
accrued vacation pay on each worksheet. The value is not in the same cell on each worksheet. How can I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I accrue certain cell values across multiple worksheets?
terri
If value is not in the same cell on each worksheet you will have to manually go to each sheet and enter a formula referring back to the previous sheet's accrual. Sounds like you could use a bit more thought in formatting so's you could just refer to the same cell on each sheet. Maybe there is some type of identifier data that could be used as a locater cell on each sheet? Difficult in my estimation. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 10:58:01 -0800, terri wrote: I have numerous payroll worksheets for an employee and want to show the accrued vacation pay on each worksheet. The value is not in the same cell on each worksheet. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I paste multiple values into one cell? | Excel Worksheet Functions | |||
| combine multiple values in a table into one cell using vlookup? | Excel Worksheet Functions | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
| how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
Linear Mode
