Auto deletion of data when deleted from master file

[rajagopal]

I've MOM.xls in which i put macros that whatever u update in range D60, J60, L60 will be auto populated in cells I7, O7, Q7 in Action item tracker.xls.
The above is applicable for range D60:D69.
My requirement is whenever i delete the data in the above ranges, corresponding data in Action item tracker.xls should be deleted and a confirmation popup "Action items are succesfully deleted from Action item tracker".
Find the attached MOM.xls and Action item tracker.xls for ref.
Please help...

[Ebrow]

Every thought of doing this in Access. It would make a lot more sense to do it that way.

If you want, I could make you a quick Access example for you.

If you want to do what you are doing on excel, I would re-engineer it, and the effort would be more than creating an access database.

[zv735]

Why you don't use Command Button for Update Action item tracker.xls (Click when you sure that your complete data )
or Update Action item tracker.xls when you close Mom.xls File

[rajagopal]

I think you know the best option than me (I'm begineer in macros)
I request you to give the codes for the above.

Regards

[zv735]

See Att File

If u want to Update data when u close file, move code

Call Call UpDateData

in Private Sub CommandButton1_Click()

to Private Sub Workbook_BeforeClose(Cancel As Boolean)

Thank you

[rajagopal]

I don't want the data to be updated before closing the file.
Simultaneous updation is preferred which is available in your earlier MOM.xls
My requirement is:
1. Consider you're updating MOM.xls which means Action item tracker.xls is also updated immly.
2. If you delete data in cell D60:L69 in MOM.xls, the same has to be deleted in Action item tracker.xls
I hope this can be done
Please help..

Regards

[zv735]

It's not complication but you must know about VBA coding becouse only you know about what you want



see att file

Thank you

[rajagopal]

gives an error in the code
Activesheet.paste

[zv735]

I don't get any Error
I don't know, why?
but i edit code for you

see att file

[rajagopal]

Now it works. Thanks a lot.

Regards