Copy from worksheet to worksheet help

  • Thread starter Thread starter bikky
  • Start date Start date
B

bikky

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,

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

HTH,
Bernie
MS Excel MVP
 
Back
Top