Enter sheet update other worksheet with text

Closed
-Prakshe - Feb 15, 2012 at 12:34 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Feb 20, 2012 at 09:28 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Feb 16, 2012 at 09:59 AM
Hi Prakshe,

Could this work:

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

Best regards,
Trowa
0
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...
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Feb 20, 2012 at 09:28 AM
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
0