It would be nice if your explanations matched your examples.

You say 24 rows on Sheet1, but you then mention B26 to B50 ... *25* rows.
So ... is it B26 to B49, or ... B27 to B50?

Next, you say Sheet2 utilizes sets of 24 columns.
Then you state A2 to W2 ... which is *23* columns,
And B2 to X2 ... which is also *23* columns.

Would you care to clarify your *exact* locations (ranges)?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Cardslinger" wrote in message
...
Information on sheet 1 is in columns with 24 rows, i.e. B1:B24, B26:B50
and
so on. Sheet 2 is in rows of 24 columns with names corresponding to the
columns on sheet 1 i.e. A2:W2 Then B2:X2. I can get the data if I
manually
select each cell on sheet 2 & =Sheet1!B2 & so on.
Is there a formula to accomplish this as each set of imported data to the
rows on sheet 2 are 24 row numbers apart. (sheet 2 b4 = sheet 1 c50 &
sheet 2
b5 = sheet 1 b74).
Thanks