I'll try to describe this as best i can, i'm sure there's a simple solution.
I'm copying say Range("A121:D121,M121:O121")
I then want to paste it into another sheet on a variable row number but i need A121:D121 to paste into A(x):D(x) which it does but then M121:O121 must paste into M(x):O(x) whereas currently it simply carries on the paste range eg. E(x):G(x)
Sure it will be some kind of PasteSpecial but struggling to find anything.
Any help would be appreciated.
NOTE: There will be around 40 ranges in the copy and paste, the destination has formulas which extract the YEAR and MONTH, just to give some context.
I'm copying say Range("A121:D121,M121:O121")
I then want to paste it into another sheet on a variable row number but i need A121:D121 to paste into A(x):D(x) which it does but then M121:O121 must paste into M(x):O(x) whereas currently it simply carries on the paste range eg. E(x):G(x)
Sure it will be some kind of PasteSpecial but struggling to find anything.
Any help would be appreciated.
NOTE: There will be around 40 ranges in the copy and paste, the destination has formulas which extract the YEAR and MONTH, just to give some context.