Hi, I'm new VBA macro and understand you should optimize code where possible. Any thoughts on optimizing this:
All I'm doing is copying data from a column and pasting it a few columns over, moving a couple columns over and repeating this for 12 periods.Please Login or Register to view this content.
There are 3 different period lengths.
The first I'm pasting 6 columns over, then 4 columns over 8 times and finally 2 columns over 3 times.
Any help would be great!
Bookmarks