Thanks so much!!! This is what I need! I think I did a bad job of explaining however, I need the macro to continue copying until the end of the row not stoping at column F. Can you help with that?