PDA

View Full Version : Auto deletion of data when deleted from master file



rajagopal
06-08-2007, 08:13 AM
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
06-13-2007, 12:12 PM
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
06-13-2007, 07:42 PM
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
06-13-2007, 10:17 PM
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
06-15-2007, 07:14 AM
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
06-17-2007, 11:07 PM
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
06-19-2007, 06:42 PM
It's not complication but you must know about VBA coding :thumb becouse only you know about what you want :cloud9:



see att file

Thank you :beerchug:

rajagopal
06-20-2007, 01:09 AM
gives an error in the code
Activesheet.paste

zv735
06-20-2007, 04:50 AM
I don't get any Error
I don't know, why?
but i edit code for you

see att file

rajagopal
06-20-2007, 05:31 AM
Now it works. Thanks a lot.

Regards