Thank you for the reply. Is there a way to automate the whole thing. Such as a macro that will copy from test1 and then paste to test2?