CathLavoie
10-26-2011, 05:55 AM
Hi!
I have a question about range name / reference.
In the cell A1 of the Sheet2 ("data"), I have a value expressed with a letter and a number. For example: H1. The value could change, it's not fixed so I can't refere to the value itself.
How can I select the cell of Sheet1 referenced in "data"? (in this example, selecting the cell H1 of Sheet1)
I have tried a couple of things with concatenate but it does not work.
Maybe someone could help me?
Thanks so much!
I have a question about range name / reference.
In the cell A1 of the Sheet2 ("data"), I have a value expressed with a letter and a number. For example: H1. The value could change, it's not fixed so I can't refere to the value itself.
How can I select the cell of Sheet1 referenced in "data"? (in this example, selecting the cell H1 of Sheet1)
I have tried a couple of things with concatenate but it does not work.
Maybe someone could help me?
Thanks so much!