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.
0
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