Hi to all,

I have workbook 1 and workbook 2, and I need a way to update workbook2 automatically when I do changes in workbook 1, I mean, when I delete range content (e.g. C7 or row 5, etc), the corresponding range be deleted in workbook 2 automatically.

The content to delete is located in different sheet names in both workbook, and in different tables structure, I mean C7 or row 5 is in SheetX in WBook1 but identical C7 content or row 5 content is located in SheetABC in Wbook2 and in different positions, C7 could be located in H20, row 5 could be row17.

I hope make sense, may somebody suggest me how can I get this?

Any help would be very appreciated.

Regards