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 to reference the previous sheet?
Thanks much
Last edited by bikky; 07-07-2006 at 04:33 AM.
bikky,
There is no automatic way of updating the references the way you want.
HTH,
Bernie
MS Excel MVP
"bikky" <bikky.2akgo0_1152261005.0303@excelforum-nospam.com> wrote in message
news:bikky.2akgo0_1152261005.0303@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks