Rather than starting another Excel Help thread...
I know that there are probably more elegant ways to achieve the end goal, but this project has sort of evolved to needing to ask this question.
I have a spreadsheet with several tabs. The first tab is the "master" where I can enter information needed for all of the other tabs. There are then individual tabs for each output. The output tabs reference back to the master: sometimes to information that is static to all output tabs and some information that is variable.
I actually have questions on two levels, though they are interconnected
Duplicating tabs
This is a 'one time' question. Currently, there are 13 output tabs and I need to increase to 27 (this will be my maximum needed for this project). Is there a way to have the new tabs reference the correct cell on the master tab for the variable data.
Simplifying: If
- Cell A1 in Output Tab 1 references Cell B3 on the master tab (=Master!B3)
- Cell A1 in Output Tab 2 references Cell B4 on the master tab (=Master!B4)
- Cell A1 in Output Tab 3 references Cell B5 on the master tab (=Master!B5)
How can I create Output Tab 4 to have Cell A1 reference Cell B6 on the master tab (=Master!B6)?
Master and Slaves
I am sure there is some name to what I am looking for and if it does exist, it may trump the first question above. And no, I am not inquiring about B & D.
Can I set up a system where if I need to make a global change to the output tabs, I can make it on one tab and all of the other tabs will automatically update?
For example, if I need the calculation in cell D14 to change from "=sum(A1 * A2)" to be "=sum(A1 / A2)", is there a way to set this up to change automatically on each output tab? Or is the only way to accomplish this beb to make the change in cell D14 in each Output tab (which I know I could accomplish via copy and paste, but there is always the danger or missing something).
OK Alex: prove your mettle!