Thread: excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tj tj is offline
external usenet poster
 
Posts: 6
Default 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