Use the following formula in cell B52

=INDIRECT("'Hourly Analysis'!BI"&507+(ROW()-52)*24)

and fill down as far as you need to go. Be careful with the mix of single
quotes (') and double quotes (").




"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.