Now that I think about it, I prefer the formula

=OFFSET($BI$1507,(ROW()-52)*24,0,1,1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Chip Pearson" wrote in message
...
I misread your cell addresses. Use

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

in cell B52 and fill down as far as you need to go.

This formula can be adapted to read any series of data from colum BI.
Change the 1507 to the first row with source data, 52 to the start row of
the result formulas, and 24 to the interval between the returned values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Chip Pearson" wrote in message
...
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.