Worksheet name input to move data from one worksheet to another

Closed
jessica khani Posts 1 Registration date Monday January 28, 2013 Status Member Last seen January 28, 2013 - Jan 28, 2013 at 03:31 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2013 at 06:53 AM
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.

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Jan 29, 2013 at 03:54 AM
Hi jessica khani,

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:

Worksheet1 cell A1: =worksheet2!$F$129
Worksheet2 cell F129: =worksheet3!$A$1

When any value is entered in cell A1 of "worksheet3" it will appear in both the sheets.

Kindly get back if there are any further queries.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 29, 2013 at 06:53 AM
A slight twist on Zohaib answer can be

1, enter at some fixed place what sheet name you would like to use (lets say Z1=worksheet2)

2. use combination of indirect and address function to get the value from worksheet2!$F$129
=INDIRECT(ADDRESS(129,6,1,1,Z1))
or some thing like
=INDIRECT(Z1 & "!" &"F129")
0