All I meant by new column was that it would paste to the next open column. Sorry for any confusion

Since I have to do this operation on four seperate tabs within a workbook, how does this change the code

Thanks for your help.