My boss fills out her timecards in Quattropro. She wants to do a running
tally of her vacation time so this requires Quattropro to look at the
previous sheet and add a static number. The formula she currently uses in
Quattropro is the following: @sum(010706:A22 + 4.46). 010706 is the sheet
prior to the current sheet she is working on, 011406. When she copies this
formula to the next sheet it changes to reference the sheet she is copying
from. So if her next sheet is entitled 012106 the formula changes to @sum
(011406:A22 + 4.46). Is this possible in Excel as we are transitioning
completely to Excel from Quattropro. Thank you.