What you have doesnt do anything different then what I started with. I need it to do a cut and paste after the lookup so all formats are carried with. Dont ask why, it is a long explaination. Can it be done

Thanks