empty cell after links are updated

[Justair07]

Hello,

I have two workbooks that are linked to each other, Workbook W1 and Workbook W2. When some types something in Workbook W1, in cell A2, it then updates to Workbook W2, in cell A2. Then the people who have access to Workbook W2 will respond in cell B2 and that will update to Workbook W1 in cell B2. Basically it works like this W1,A2=W2,A2 and W2,B2=W1,B2.

The problem I'm encountering is creating an event macro that will clear out W2,B2 if W1,A2 changes.

I've tried workbook_change and workbook_calculate events and have had no luck.

If anyone has any idea how I can fix fix this issue I would greatly appreciate some help.

Thank you,

-Justair

[ragulduy]

I think you need this:

Please Login or Register  to view this content.

in the sheet object you want it to apply to, changing workbookname and sheetname as appropriate.

[Justair07]

Worked great!

Is there a way to make this apply to all A2:A and B2:B so it will work for multiple cells? I need the code to apply to a lot of cells at once.

Maybe your code can be modified to work with this?

Please Login or Register  to view this content.

[ragulduy]

You could either use:

Please Login or Register  to view this content.

or with the method you post:

Please Login or Register  to view this content.

[Justair07]

I was incorrect in my original post. I just noticed that I actually need certain cells cleared on worksheet change. I tried the below code but it didn't work.

For example. If F12 is changed then I need F22 cleared and so on....

Please Login or Register  to view this content.

Is there an easy way to accomplish this?

[ragulduy]

I think you want:

Please Login or Register  to view this content.

but I'm not sure. That will work for cells F12 to F15 and clear cells F22 to F25

[Justair07]

Perfect! Thank you very much for your help! I actually learned a thing or two also.