So there was an person that was trying to make a tracker for our business group, and unfortunately he left. Basically I want to be able to add columns without the macro "breaking" but I have no earthly idea on how to do that. This macro is way over my head.


I just want to be able to add columns to the "Compliance tracker" tab and still have the macro for sending emails work. Also, if possible when the "Tax return status" is changed, how would I make it so the info in the "Already sent?" column auto deletes?Compliance Tracker - Corporate Draft - final.xlsm