Enter sheet update other worksheet with text

Closed
-Prakshe - Feb 15, 2012 at 12:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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



Related:

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Feb 16, 2012 at 09:59 AM
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...
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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