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" wrote in message
...

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