i'm trying to reference data in column A on sheet1 so it shows up in 10 different grid structures on sheet2, the grids are the following sizes - columns x rows - 3x6, 3x6, 7x6, etc...

the grids represent storage locations for parts, the parts are always changing so i was using the formula =INDIRECT("Sheet1!$A"&ROW()) and have also tried the formula =INDEX(Sheet1!A:A,ROW()) everything works fine except for the fact that when i auto fill to another column it changes A to B and so on, i need a formula that will use all the data in column A on sheet1 so it carries over on the grid like so:

column A sheet1 =
|1|
|2|
|3|
|4|
|5|
|6|
|7|
|8|

grid on sheet2 =
|1|7|


|2|8|
|3|etc...|
|4|
|5|
|6|

i've tried indirect formula which also works but i have to type each formula out(over 300), is there a way to do this with auto fill to save time? or maybe a chart or table that looks like the grid i want?

It would be helpful if you were to attach a workbook to a post with some representative data (delete anything sensitive) and a description there of what needs to be done. You do attach one via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]