markpem
06-02-2016, 05:56 AM
Hello
I am wanting hopefully some VBA code if possible that the following can be done?
"if the current month and the previous month are not the same and then write the previous month and current month's text to an output column"
However if both months are the same it can be skipped
(Though if it's easier all can be counted (even consulting to consulting) and I can filter it out when I grab the data into a pivot table)
Many thanks for any advice
Previous Month
Current Month
Output
Consulting
Accepted
Consulting to Accepted
Consulting
Consulting
Consulting
Agreed
Consulting to Agreed
Agreed
Finalized
Agreed to Finalized
I am wanting hopefully some VBA code if possible that the following can be done?
"if the current month and the previous month are not the same and then write the previous month and current month's text to an output column"
However if both months are the same it can be skipped
(Though if it's easier all can be counted (even consulting to consulting) and I can filter it out when I grab the data into a pivot table)
Many thanks for any advice
Previous Month
Current Month
Output
Consulting
Accepted
Consulting to Accepted
Consulting
Consulting
Consulting
Agreed
Consulting to Agreed
Agreed
Finalized
Agreed to Finalized