excel formula

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

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
 
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
| 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with previous sheet reference formula 1
IF formula question - nesting multiple functions. 2
Help with Index formula 2
Excel Formula Required for VBA code for excel 0
Is it possible? 7
Get date from prior sheet and add 7 days 6
Excel vba code to match duplicates 4
Payroll verification hrs and time off 6

Back
Top