Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
trying to create a payroll spreadsheet using "sheets" as
payperiods. Having trouble creating incrimental increase of accrued Vacation Sick and Comp without re-entering data on each sheet. need a formulas for the following: "previous sheet value" + "Accrued time" equals new value "previous sheet value" "+ or - comp" equals new value I have 26 Sheets representing pay periods. I need a previous sheet reference instead of a specific sheet reference. Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
Excel does not have a way to reference other sheets relatively; the
references are always absolute. So a reference to Sheet1 from Sheet2 will stay Sheet1 when copied to Sheet3. You could go to Sheet3 and do a Find/Replace to change Sheet1 references to Sheet2. -- Jim Rech Excel MVP "TJ" wrote in message ... | trying to create a payroll spreadsheet using "sheets" as | payperiods. Having trouble creating incrimental increase | of accrued Vacation Sick and Comp without re-entering | data on each sheet. need a formulas for the following: | | "previous sheet value" + "Accrued time" equals new value | | "previous sheet value" "+ or - comp" equals new value | | I have 26 Sheets representing pay periods. I need a | previous sheet reference instead of a specific sheet | reference. Please help | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |