are you sure the data isn't
Day 1 B13:B36
Day 2 B49:B72
Day 3 B83:B106

Assuming you refer to the day number in a cell on sheet 2
if you want each cell to come over individually

for each hour

=indirect("Sheet1!B"&(12+hour+36*(day-1)))


"Karl in Springfield" wrote:

Spreadheet 1 "Hourly" is referring to Spreadsheet 2 "Daily".

Spreadsheet 1 will contain 744 hourly values in a continuous column.
Spreadsheet 2 has the required data arranged by days with twelve rows
between each successive day's set of 24 hour data.

How do I easily capture the easily refer to the data on Spreadsheet which on
Day 1 is in cells B13:B36, on Day 2 is in cells B49:B62, on Day 3 is in cells
B73:B106, etc.?

There's a pattern, but Excel's not picking it up correctly when I copy the
formulas.