automatically update date based off of completion date

[nathanvolker12]

Hello all,

I am having trouble writing some VBA.
The system that I am working on is to build a fleet management system for our mechanic to track services needing to be performed on vehicles we own.

Currently in A1, A2, A3 I have the table headers of Due Date, Service Needed, and Completed Date.
As an example it says 8/10/2018 Oil Change 8/13/2018
Which correspond to the table headers appropriately.
I need a VBA code that implys when the completion date is entered it will automatically create another line in the table and readd the oil change but the due date will now be 3 months out from the completion date.

Not sure if I need to upload a screen shot of the table that I currently have. If anything helps in figuring this out let me know.​

 

[Fluff]

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites where you have asked this question.