All.
I have formulas in cells A1:A3.
I would like to have my macro:
1. Copy the formula from that range (A1:A3) to B1:B3.
2. It will then go back to A1:A3 & copy/paste value that range.
This will happen daily so the range will move to the right with each passing day.
I've used the recorder but then I would have to change the range in the code manually.
Any & all guidance is appreciated.
I have formulas in cells A1:A3.
I would like to have my macro:
1. Copy the formula from that range (A1:A3) to B1:B3.
2. It will then go back to A1:A3 & copy/paste value that range.
This will happen daily so the range will move to the right with each passing day.
I've used the recorder but then I would have to change the range in the code manually.
Any & all guidance is appreciated.