Enter sheet update other worksheet with text [Closed]
Report
-Prakshe
-
TrowaD
TrowaD
- Posts
- 2742
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 4, 2021
Related:
- Enter sheet update other worksheet with text
- Auto notify of email when excel sheet updated ✓ - Forum - Excel
- Automatically update master worksheet from other worksheets ✓ - Forum - Excel
- Generate Email Notifications for Excel Sheet Updates - How-To - Excel
- Which function will you use to enter current time in worksheet cell ✓ - Forum - Office Software
- Send email when a cell changed in excel - Forum - Excel
3 replies
TrowaD
- Posts
- 2742
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 4, 2021
Hi Prakshe,
Could this work:
Sheet2 A2: =IF(Sheet1!A2="","","Taken")
Best regards,
Trowa
Could this work:
Sheet2 A2: =IF(Sheet1!A2="","","Taken")
Best regards,
Trowa
Aushe
Thanks for your reply Trowa, but I need to transfer data across the files,let me explain it to you again
1. I have two spreadsheets Test1.xls and Test2.xls
2. Test1.xls has multiple worksheets with each cell having some values
3. Test2.xles has multiple worksheets as well which matches Test1.xls
4. If I alter a value in a cell in Test1.xls, the corresponding cell in the Test2.xls has to change as "Taken".
eg: Test1.xls --> Sheet1.A2 -" if I enter a value as Sam"
Test2.xls ---> Sheet1.A2 - should display "Taken"
[the data has to change in the same address location]
so if i alter any cell in Test1,it should change in Test2.
could you please help me, its urgent...
1. I have two spreadsheets Test1.xls and Test2.xls
2. Test1.xls has multiple worksheets with each cell having some values
3. Test2.xles has multiple worksheets as well which matches Test1.xls
4. If I alter a value in a cell in Test1.xls, the corresponding cell in the Test2.xls has to change as "Taken".
eg: Test1.xls --> Sheet1.A2 -" if I enter a value as Sam"
Test2.xls ---> Sheet1.A2 - should display "Taken"
[the data has to change in the same address location]
so if i alter any cell in Test1,it should change in Test2.
could you please help me, its urgent...
TrowaD
- Posts
- 2742
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 4, 2021
Hi Aushe,
Spreadsheets, worksheets, tabs all mean the same; the individual sheets in an Excel file or workbook.
Now that that's cleared, the workaround remains the same:
Test2.xls Sheet1 A2 formula:
=IF('C:\Documents\Excel Files\[Test2.xls]Sheet1'!A2="","","Taken")
Correct the files path.
Note: When both workbooks are open the change will happen immediatly, if not then a confirmation is prompted to adjust the workbook when opened.
Best regards,
Trowa
Spreadsheets, worksheets, tabs all mean the same; the individual sheets in an Excel file or workbook.
Now that that's cleared, the workaround remains the same:
Test2.xls Sheet1 A2 formula:
=IF('C:\Documents\Excel Files\[Test2.xls]Sheet1'!A2="","","Taken")
Correct the files path.
Note: When both workbooks are open the change will happen immediatly, if not then a confirmation is prompted to adjust the workbook when opened.
Best regards,
Trowa
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Disabled Write Protection on a USB