lol Yes it is midnight but programmers are night owls well mostly haha. This will actually be really easy to write. Do do it effectively though we will need to have the original data on the first worksheet of your workbook and then we will have another worksheet added and place the data on there. Then we will go ahead and just run the code. Now this code will be written for 2 manipulations I am assuming you may want the ability to add more so I will give it some thought and see how I can code it to where you can update that in the future. I might be done tonight or sometime tomorrow. Thanks