Enter sheet update other worksheet with textClosed

Question

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



Configuration: Windows XP / Internet Explorer 7.0

TrowaD · Answer

Hi Prakshe,

Could this work:

Sheet2 A2: =IF(Sheet1!A2="","","Taken")

Best regards,
Trowa

Aushe · Answer

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 · Answer

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

Enter sheet update other worksheet with text

3 replies

Subscribe To Our Newsletter!