Hi all
I think this question has probably been asked before, but I'm clearly not fantastic at transferring from one example to mine...
Basically, I have an Excel sheet with 7 sheets (we'll go with A, B, C, D, E, F and G). With the exception of Sheet G, all are set up exactly the same.
In Column E of each sheet is a reference code (eg: 9/3). At present, I manually enter the corresponding value into the cells in Column H, but they do occasionally change (this, of course, would mean that I have to manually update every cell that has that reference code). I wonder if it would be possible to enter these corresponding values into cells on Sheet G (unused at present) and use a code on each spreadsheet to automatically update these values.
In an ideal world, if I changed the cell in Sheet G, it would automatically update all instances of that value in Sheets A-F (in Column H).
The other thing is that there are approximately 27 different options for codes. If I could maintain these in a table on Sheet G and just update this, it would make my life so much easier. Sometimes the values in Column E themselves will change too, so it would be fantastic to refer them to all possible codes.
I got as far as thinking that it would be an =IF start, but then I thought I'd better check with the experts.
In my mind, in Sheet G, I would allow for a heading to the table (across A1, B1) and a column visually defining the values (Column A), but would put the values from B2 down to B29.
I hope this doesn't complicate it any further, but...
If, for example, I entered "A/1" in Sheet B E25, is it possible to enter a formula that would mean that the value of Sheet G B2 would appear in Sheet B G25? Or "B/3" in Sheet F E99, to get Sheet G B8 to appear in Sheet F H99?
Any advice?
I think this question has probably been asked before, but I'm clearly not fantastic at transferring from one example to mine...
Basically, I have an Excel sheet with 7 sheets (we'll go with A, B, C, D, E, F and G). With the exception of Sheet G, all are set up exactly the same.
In Column E of each sheet is a reference code (eg: 9/3). At present, I manually enter the corresponding value into the cells in Column H, but they do occasionally change (this, of course, would mean that I have to manually update every cell that has that reference code). I wonder if it would be possible to enter these corresponding values into cells on Sheet G (unused at present) and use a code on each spreadsheet to automatically update these values.
In an ideal world, if I changed the cell in Sheet G, it would automatically update all instances of that value in Sheets A-F (in Column H).
The other thing is that there are approximately 27 different options for codes. If I could maintain these in a table on Sheet G and just update this, it would make my life so much easier. Sometimes the values in Column E themselves will change too, so it would be fantastic to refer them to all possible codes.
I got as far as thinking that it would be an =IF start, but then I thought I'd better check with the experts.
In my mind, in Sheet G, I would allow for a heading to the table (across A1, B1) and a column visually defining the values (Column A), but would put the values from B2 down to B29.
I hope this doesn't complicate it any further, but...
If, for example, I entered "A/1" in Sheet B E25, is it possible to enter a formula that would mean that the value of Sheet G B2 would appear in Sheet B G25? Or "B/3" in Sheet F E99, to get Sheet G B8 to appear in Sheet F H99?
Any advice?
