Hi - This site has helped me so much I thought I'd sign up and ask my own question and hopefully help others
My question:
What would be the VB code for when I delete data from a cell it then automatically copies the formula that's in cell 200 of that row into the newly deleted cell?
eg.
1. Delete data in cell A1
2. Formula from A200 gets put into cell A1
I also want it to work for all my columns which is A to AR.
Another example:
1. Delete data from F68
2. Formula from F200 populates into F68
Any help would be greatly appreciated!
Thank you in advance
My question:
What would be the VB code for when I delete data from a cell it then automatically copies the formula that's in cell 200 of that row into the newly deleted cell?
eg.
1. Delete data in cell A1
2. Formula from A200 gets put into cell A1
I also want it to work for all my columns which is A to AR.
Another example:
1. Delete data from F68
2. Formula from F200 populates into F68
Any help would be greatly appreciated!
Thank you in advance