I am not sure what you are asking. It seem that you want to copy record from one sheet to other one. It can be done. You need to explain with example. Or better. Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.