Copy from worksheet to worksheet help
 

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

Copy from worksheet to worksheet help
 

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