I have a worksheet for calculating flexi hours at work, and need a bit
of help. The sheet works fine as a whole, and i can copy to a new
sheet and start again, 4 weeks per sheet. however what i'd like to do
is as well as copying the formlae for calculating the hours, have a
cell at the top of my sheet for cr/dr carried over to reference the
final calculation from the previous sheet.

i have this in the form of
=IF(Sheet1!S45<>"-",Sheet1!S45,IF(Sheet1!Q45="-",0,Sheet1!Q45))
however, when i copy all the data from sheet 2 to sheet 3, it still
references sheet 1. is there any way this can be done?


--
bikky
------------------------------------------------------------------------
bikky's Profile: http://www.excelforum.com/member.php...o&userid=36149
View this thread: http://www.excelforum.com/showthread...hreadid=559228

bikky,

There is no automatic way of updating the references the way you want.

HTH,
Bernie
MS Excel MVP


"bikky" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I have a worksheet for calculating flexi hours at work, and need a bit
> of help. The sheet works fine as a whole, and i can copy to a new
> sheet and start again, 4 weeks per sheet. however what i'd like to do
> is as well as copying the formlae for calculating the hours, have a
> cell at the top of my sheet for cr/dr carried over to reference the
> final calculation from the previous sheet.
>
> i have this in the form of
> =IF(Sheet1!S45<>"-",Sheet1!S45,IF(Sheet1!Q45="-",0,Sheet1!Q45))
> however, when i copy all the data from sheet 2 to sheet 3, it still
> references sheet 1. is there any way this can be done?
>
>
> --
> bikky
> ------------------------------------------------------------------------
> bikky's Profile: http://www.excelforum.com/member.php...o&userid=36149
> View this thread: http://www.excelforum.com/showthread...hreadid=559228
>