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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2013 at 06:53 AM
Related:
- Worksheet name input to move data from one worksheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- How do you add a username or author to a worksheet - Guide
- How to input @ in laptop - Guide
- Input phone lock code sos - Phones, PDA & GPS Forum
- Automatically run a macro when opening a worksheet - Guide
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
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.
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.
Jan 29, 2013 at 06:53 AM
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")