Hi
I'm looking for advice on the following.
Each week i wish to 'manually' change a letter within a field. Say this is set to 'B' at the moment and is held in cell A1 on sheet2.
For various other cells i have a formula which references another sheet and i wish to use that letter as part of the new formula.
So say i have the formula within sheet2 referencing a field B2 field in sheet1 stating: =sheet1B2, this correctly returns me the value held.
What I wish to do is to save me updating many formula's, for this to 'reference' the value B from cell A1 on sheet2. So later if i was to manually change the value of cell A1 on sheet to to 'F' then my formula would pick up the value from sheet1F2 instead. If i change A1 to 'D', then it will reference sheet1D2 instead.
Hope this makes sense and thanks in advance, i think the answer lies within using the index or references but i could be wrong.
Thanks
P
I'm looking for advice on the following.
Each week i wish to 'manually' change a letter within a field. Say this is set to 'B' at the moment and is held in cell A1 on sheet2.
For various other cells i have a formula which references another sheet and i wish to use that letter as part of the new formula.
So say i have the formula within sheet2 referencing a field B2 field in sheet1 stating: =sheet1B2, this correctly returns me the value held.
What I wish to do is to save me updating many formula's, for this to 'reference' the value B from cell A1 on sheet2. So later if i was to manually change the value of cell A1 on sheet to to 'F' then my formula would pick up the value from sheet1F2 instead. If i change A1 to 'D', then it will reference sheet1D2 instead.
Hope this makes sense and thanks in advance, i think the answer lies within using the index or references but i could be wrong.
Thanks
P