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