Enter sheet update other worksheet with text
[Closed]
Report
-Prakshe
-
TrowaD
TrowaD
- Posts
- 2819
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 25, 2021
Related:
- Enter sheet update other worksheet with text
- Auto notify of email when excel sheet updated ✓ - Forum - Excel
- How to split excel sheet into multiple worksheets based on rows ✓ - Forum - Excel
- Generate Email Notifications for Excel Sheet Updates - How-To - Excel
- Master sheet to multiple worksheets - How-To - Excel
- Automatically update master worksheet from other worksheets ✓ - Forum - Excel
3 replies
TrowaD
- Posts
- 2819
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 25, 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
- 2819
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 25, 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
