I have a worksheet that is identical in all values other than price.
All data is collected on worksheet one. Work sheet one has a column where all prices are input, and they are currently drawing from worksheet 2.
My formula is =worksheet2!$F$129 .
I can move from worksheet2, where we have "x" pricing to worksheet3 where i have "y" pricing by doing a find and replace action. I need something more technical though, so i am wondering if there is a formula i can type into excel that will allow me to simply type in "worksheet3" and have my cells with the formula "=worksheet2!$F$129" update automatically.
Help is appreciated - i hope this was communicated clearly.
Worksheet name input to move data from one worksheet to another
If the values in cell "F129" of "worksheet2" comes from "worksheet3", please add a reference to the cell from "worksheet3" in cell "F129" of "worksheet2".
For example: If we need the updated value in cell A1 of "worksheet1" from cell "F129" of "worksheet2" which in turn receives its value from cell A1 of "worksheet3", I will put the below formulas in the respective cells: