p45cal,

Words cannot express how awesome this is, thank you. I spent the better part of my morning trying to figure out how to do this using loops, offset, copy pasting, end up, etc using vba. I opened up your code and its nothing I have every used or seen before. Actually I knew the .selection and .delete parts. I thought I knew some stuff but I just realized I haven't even left the garage. Furthermore I really appreciate your help because I felt guilty during the day that I just uploaded a file and asked for someone to help code it in lieu of providing what code I knew and adjust thru the recommendations. I was actually going to delete my post but so I glad I did not and you helped me. Thanks a bizzillion and loop that with some code for another bizzilion times!!! I believe this is not the first time you have helped me, thank you for all your efforts. Now I am going to study your code and google what the components do so I can add it to my small knowledge base. And finally, I will never upload a file without having some code, however rudimentary. This forum is a great place!!! Thanks!