Hi

I´m somewhat unsure, which sheet is the one you enter the values, and which
one has to refer to cells on another sheet.

When you are entering values into sheet 'HOURLY ANALYSIS', then on another
sheet enter just the same formula like the one you did give here, i.e. into
cell B52 you enter the formula
=IF('HOURLY ANALYSIS'!BI1507="","",'HOURLY ANALYSIS'!BI1507)
, and copy it down/up - cell references are adjusted automatically when
copied.

When you enter your values into another sheet, and want 'HOURLY ANALYSIS'
sheet to mirror them, then into 'HOURLY ANALYSIS'!BI1507 enter the formula
=IF('Sheet Name'!BI52="","",'Sheet Name'!BI52)
, and copy it down/up.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"rhhince" wrote in message
oups.com...
I need to reference a cell from a another sheet that is always 24 rows
away and in same column. i.e.

B52='HOURLY ANALYSIS'!BI1507
B53='HOURLY ANALYSIS'!BI1531

How to I get 'HOURLY ANALYSIS'!BI1531 to change automatically without
changing it manually?
Thanks.