Insert columns from Sheet 2 into Sheet 1

Hello,

I have four columns of Data with Formulas in Sheet2 columns P,Q,R and S.

I simply want to copy these columns, with formatting etc and place them between Columns O and P on Sheet1.

My current code below copies over the data in the columns on Sheet1.

Please Login or Register  to view this content.

Any help appreciated.

Hi Paul,

Many thanks for your help. It works, but it replaces four columns in the spreadsheet.