Hi,
I am try to do what I supposed to be a "normal" thing, but I am in truble!
is there a way in excel to specify the reference of a cell in another sheet with a formula and not with fixed columns or rows?
In the specific I have two sheets and I would like to link the cell using this "formula":
that means
the point is that I don't know how to make the column reference a formula and not a specified value.
I would like to NOT use macros...
is it possible!?
Thanks a lot!
I am try to do what I supposed to be a "normal" thing, but I am in truble!
is there a way in excel to specify the reference of a cell in another sheet with a formula and not with fixed columns or rows?
In the specific I have two sheets and I would like to link the cell using this "formula":
Code:
Sheet2!C1=Sheet1! ((COLUMN(C1)+3)/2) & "1"
that means
- in cell C1 of Sheet2 takes the value in Sheet1 in cell (3+3)/2 -> 3->C
- in cell E1 of Sheet2 takes the value in Sheet1 in cell (5+3)/2 -> 4->D
- in cell G1 of Sheet2 takes the value in Sheet1 in cell (7+3)/2 -> 5->E
- ...
the point is that I don't know how to make the column reference a formula and not a specified value.
I would like to NOT use macros...
is it possible!?
Thanks a lot!