Replace formula after VBA has cleared data.

[greggmorgangolf]

That was extremely helpful. Thank you.

I have added an iferror(vlookup for columns H, J, and L to automate the tracker data entry where possible.

I am wondering if there is a way of removing the data if a dependent cell to the left is changed in the same way without removing/overwriting my iferror(vlookup formula in cells H, J and L which will be hidden from users when the sheet is protected?

Visual of senario below.

 

[Joe4]

Duplicate to: How to repeat an If Change Code in multiple descending rows in a worksheet?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.