What I am trying to do is take a 7 column by 500 row grid of information from a worksheet and populate it into a grid that is 1 column by 3500 rows on another worksheet. In other words 7 columns of data will become 1 column with 7 rows. I can not use the copy & paste function, because the original grid is initially blank. While info is being entered into the grid, I want it to be displayed on the next worksheet in the format I described. I have tried the transpose function and it does not seem to work for me, I may be doing something wrong though. Any help would be appreciative.
Here is an example of the formulas:
cell A1 : ='Instrument Tags'!T3
cell A2 : ='Instrument Tags'!U3
cell A3 : ='Instrument Tags'!V3
cell A4 : ='Instrument Tags'!W3
cell A5 : ='Instrument Tags'!X3
cell A6 : ='Instrument Tags'!Y3
cell A7 : ='Instrument Tags'!Z3
When I try to carry these over to the next 7 rows, here is what the formulas look like:
cell A8 : ='Instrument Tags'!T10
cell A9 : ='Instrument Tags'!U10
cell A10 : ='Instrument Tags'!V10
cell A11 : ='Instrument Tags'!W10
cell A12 : ='Instrument Tags'!X10
cell A13 : ='Instrument Tags'!Y10
cell A14 : ='Instrument Tags'!Z10
But this is what I am assuming it sould look like:
cell A8 : ='Instrument Tags'!T4
cell A9 : ='Instrument Tags'!U4
cell A10 : ='Instrument Tags'!V4
cell A11 : ='Instrument Tags'!W4
cell A12 : ='Instrument Tags'!X4
cell A13 : ='Instrument Tags'!Y4
cell A14 : ='Instrument Tags'!Z4
Here is an example of the formulas:
cell A1 : ='Instrument Tags'!T3
cell A2 : ='Instrument Tags'!U3
cell A3 : ='Instrument Tags'!V3
cell A4 : ='Instrument Tags'!W3
cell A5 : ='Instrument Tags'!X3
cell A6 : ='Instrument Tags'!Y3
cell A7 : ='Instrument Tags'!Z3
When I try to carry these over to the next 7 rows, here is what the formulas look like:
cell A8 : ='Instrument Tags'!T10
cell A9 : ='Instrument Tags'!U10
cell A10 : ='Instrument Tags'!V10
cell A11 : ='Instrument Tags'!W10
cell A12 : ='Instrument Tags'!X10
cell A13 : ='Instrument Tags'!Y10
cell A14 : ='Instrument Tags'!Z10
But this is what I am assuming it sould look like:
cell A8 : ='Instrument Tags'!T4
cell A9 : ='Instrument Tags'!U4
cell A10 : ='Instrument Tags'!V4
cell A11 : ='Instrument Tags'!W4
cell A12 : ='Instrument Tags'!X4
cell A13 : ='Instrument Tags'!Y4
cell A14 : ='Instrument Tags'!Z4