Hi,
I am very knew to VBA, just starting actually. I am looking for a way to automate a report. What I am looking for is:
If Months(column A) is 12 and Days(column B) < 365 then Days +30,
If Months is 6 and Days < 180 then Days +30,
If Months is 3 and Days < 90 then Days +30,
so like for row 3, Months is 12 and Days is 344, I would like to get 344+30 = 374
I do not want to use a formula, this report is extensive and I want to create one macro to deal with it in one press of a button
I would really appreciate any help on this.
Thanks!
I am very knew to VBA, just starting actually. I am looking for a way to automate a report. What I am looking for is:
If Months(column A) is 12 and Days(column B) < 365 then Days +30,
If Months is 6 and Days < 180 then Days +30,
If Months is 3 and Days < 90 then Days +30,
so like for row 3, Months is 12 and Days is 344, I would like to get 344+30 = 374
I do not want to use a formula, this report is extensive and I want to create one macro to deal with it in one press of a button
I would really appreciate any help on this.
Thanks!