I am apparently having trouble figuring out your layout and what you want to do with it. Can you create a sample workbook where on Sheet1 you show existing data similar to what you actually have as real data and then on Sheet2 you copy that exact data and then insert the columns you want inserted and then attach a copy of that workbook to your response so that we can see exactly what you are trying to describe to us?