Hi everyone, I have not posted in the forum in 5 years so I apologize if I miss any guidelines. Thank you for any help.
Here is my problem:
I need to copy the formulas from a prior month column in my worksheet and paste it into the current month column. I then need to copy and paste values into the prior month column. So basically move formulas from prior month to current month and then remove formulas and replace with values in prior month.
Example:
Column A Column B Column C Column D
September October November December
I need the code to select column B to copy and then paste formulas in Column C since it is currently November & prior month would be October.
It would then paste as values back into Column B to override formulas.
Next month when its December it would select Column C to copy and then paste formulas in Column D and so on.
I hope that makes sense. Thanks so much!
Bookmarks