Enter sheet update other worksheet with text

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,

Can anyone help me with this problem.

I am updating leave availability , As soon as I enter the name in one worksheet the other worksheet has to reflect "Taken" in the same location.

say for example , if I enter "Sam" in Worksheet1 at A2, then "Taken" should be updated in Worksheet 2 at same location A2.

Can anyone help, pretty please,Thanks



3 replies

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Prakshe,

Could this work:

Sheet2 A2: =IF(Sheet1!A2="","","Taken")

Best regards,
Trowa
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...
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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