Enter this in C3 and drag down until the number in the ROW function equals
the number of columns you have: =OFFSET($B$39,0,ROW(1:1)-1)

Tyro

"jeffmp21" wrote in message
...
In the first sheet titled "Budget Entry" I have data that starts in row
b39
and continues out for several hundred columns. I need this data in a
second
sheet titled Classreport starting in cell C3 and proceeding down the
column
for a corresponding number of rows. Obviously I could use "=" but this
would take a considerable amount of time. Unfortunately we are still
using
excel 2000. Is this possible? Thank you!