Worksheet name input to move data from one worksheet to another [Closed]

Report
Posts
1
Registration date
Monday January 28, 2013
Status
Member
Last seen
January 28, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
36
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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!