Hi,
i am hoping someone can help. i have been trying to do the below but i am not getting close to what i want:
in columns B:J (starting on row 4) i have data. when "Yes" is marked in column H i need the sheet to copy the line add it to the bottom of the table with the date updated by however many months is written in column F for example:
Column B has dates so the date is 21-Mar-19 in column F i have 3 (meaning 3 months repetition) so when i mark column H as "Yes" the VBA will copy this row from B:J, add it to the bottom of the table updating the date in column B to 21-Jun-19 (from column F and the 3 month repetition).
can someone help?
thank you in advance.
i am hoping someone can help. i have been trying to do the below but i am not getting close to what i want:
in columns B:J (starting on row 4) i have data. when "Yes" is marked in column H i need the sheet to copy the line add it to the bottom of the table with the date updated by however many months is written in column F for example:
Column B has dates so the date is 21-Mar-19 in column F i have 3 (meaning 3 months repetition) so when i mark column H as "Yes" the VBA will copy this row from B:J, add it to the bottom of the table updating the date in column B to 21-Jun-19 (from column F and the 3 month repetition).
can someone help?
thank you in advance.