Linking a horizontal set of cells to a vertical sets of cells

What is the quickest way to link a horizontal sets of cells to a vertical
sets of cells?
I have a spreadsheet where my values I want to plot are horizontal. I want
to link these range of horizontal cells to a another s/s where the range is
listed vertically. (I can't chagne it - it has to remain this way) I have
about 25 sheets where I want to copy the link formula.

For EX:
1 2 3 4 5 6 7 are my horizontal values on one s/s.

I want to link (copy)these over to a vertical set up.
1
2
3
4
5

I tried using an absolute reference in the link or reference formula, but
when I copy the formula to the remaining cells, it is not incrementing
properly. Someone said that you can't link horizontal and veritically...?

There are many ways to do this (just like many other things that "you can't" do).
Suppose the original cells are in B1:F1 and the links are in A2:A6. Enter this into
A2 and drag it down to A6:

=OFFSET($A$1,0,ROW()-1)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Russell-stanely wrote:

> What is the quickest way to link a horizontal sets of cells to a vertical
> sets of cells?
> I have a spreadsheet where my values I want to plot are horizontal. I want
> to link these range of horizontal cells to a another s/s where the range is
> listed vertically. (I can't chagne it - it has to remain this way) I have
> about 25 sheets where I want to copy the link formula.
>
> For EX:
> 1 2 3 4 5 6 7 are my horizontal values on one s/s.
>
> I want to link (copy)these over to a vertical set up.
> 1
> 2
> 3
> 4
> 5
>
> I tried using an absolute reference in the link or reference formula, but
> when I copy the formula to the remaining cells, it is not incrementing
> properly. Someone said that you can't link horizontal and veritically...?
>

Awesome-thanks!!

"Jon Peltier" wrote:

> There are many ways to do this (just like many other things that "you can't" do).
> Suppose the original cells are in B1:F1 and the links are in A2:A6. Enter this into
> A2 and drag it down to A6:
>
> =OFFSET($A$1,0,ROW()-1)
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Russell-stanely wrote:
>
> > What is the quickest way to link a horizontal sets of cells to a vertical
> > sets of cells?
> > I have a spreadsheet where my values I want to plot are horizontal. I want
> > to link these range of horizontal cells to a another s/s where the range is
> > listed vertically. (I can't chagne it - it has to remain this way) I have
> > about 25 sheets where I want to copy the link formula.
> >
> > For EX:
> > 1 2 3 4 5 6 7 are my horizontal values on one s/s.
> >
> > I want to link (copy)these over to a vertical set up.
> > 1
> > 2
> > 3
> > 4
> > 5
> >
> > I tried using an absolute reference in the link or reference formula, but
> > when I copy the formula to the remaining cells, it is not incrementing
> > properly. Someone said that you can't link horizontal and veritically...?
> >
>
>