B
boris
I have a vertical range, all lines one after the other. I
have a horizontal range, one column between each column
that needs to get the value from the vertical range. In
other words, on one sheet I have 12 months listed as
lines. On another sheet, I have a column for each month.
I need to link the two sheets, while allowing them to stay
dynamic (starting month is not always January, and the
names adjust themselves). One solution I thought of was a
left-hand column in the vertical sheet, where I
essentially name each row a number (first row is
month "1", and so on), and do the same at the top of the
horizontal view, skipping a column for the numbering.
That way, I can do a vlookup on the number of the column,
and place the value at the right side of the horizontal
rows. I was wondering, however, if there is a way to name
a range, and then have a formula (maybe arrays do this?)
that says "I want the 2nd piece of data from this range",
with 2nd being "draggable", so that when I copy it over in
a pattern, 3rd, 4th, and 5th will be placed in that
formula. Hope that makes sense.
boris
have a horizontal range, one column between each column
that needs to get the value from the vertical range. In
other words, on one sheet I have 12 months listed as
lines. On another sheet, I have a column for each month.
I need to link the two sheets, while allowing them to stay
dynamic (starting month is not always January, and the
names adjust themselves). One solution I thought of was a
left-hand column in the vertical sheet, where I
essentially name each row a number (first row is
month "1", and so on), and do the same at the top of the
horizontal view, skipping a column for the numbering.
That way, I can do a vlookup on the number of the column,
and place the value at the right side of the horizontal
rows. I was wondering, however, if there is a way to name
a range, and then have a formula (maybe arrays do this?)
that says "I want the 2nd piece of data from this range",
with 2nd being "draggable", so that when I copy it over in
a pattern, 3rd, 4th, and 5th will be placed in that
formula. Hope that makes sense.
boris