Linking

M

matt

I have 2 tabs in my spreadsheet. the first tab has the
following:

A B C D
4V 2R 7N 9G

On my other tab I would like this to appear without
copying and transposing:

4V
2R
7N
9G

I have alot of information on the tab so I can't just go
into each cell and hit = and then the cell. Thank you
 
D

DDM

Matt, if the data on the first sheet starts in A1 and you want to reproduce
it starting in A1 on the second sheet, put this formula in Sheet2, A1 and
copy it down:

=OFFSET(Sheet1!A$1,0,ROW()-1)
 
H

Harlan Grove

DDM said:
. . . put this formula in Sheet2, A1 and copy it down:

=OFFSET(Sheet1!A$1,0,ROW()-1)
Click to expand...
....

Same concept, possibly clearer

=INDEX(Sheet1!$1:$1,ROW())
 
M

Max

Yet another way .. using TRANSPOSE()

Assuming the entire row1 in Sheet1
may contain the source data
(up to a total of 256 cells, in A1:IV1)

In say, Sheet2
-----------------
Select A1:A256

To select, you could just type "A1:A256" in the namebox
[box with drop arrow to the left of the formula bar]
and press ENTER

Put in the formula bar: =TRANSPOSE(Sheet1!1:1)

Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
(instead of just pressing ENTER)

Excel will wrap curly braces {} around the formula:
{=TRANSPOSE(Sheet1!1:1)}
which will appear in every cell in A1:A256

For a neat look, suppress extraneous zeros from showing via:
Tools > Options > View tab > Uncheck "Zero values" > OK
 
Top