Transferring data to 2 different sheets from one main data entry sheet

[cjarollins]

I have constructed a main data sheet where we can enter data for Return Good and Credit Memo. I'd like to have the info we enter to be transferred to the RGA sheet and the Credit Memo sheet. Then, I would like the sheet set up to where after we enter the data, we can "press" a macro button? and have both the RGA sheet and the Credit Memo sheet to save. Also, after hitting the button to create the two other sheets and save, if the Main Data Sheet can reset to empty and be ready for the next entry. The other issue would be if we have more than 1 item to enter (up to 9 items), how would all that info be transferred to the corresponding sheet? A little confusing but I can answer any questions you might have.
Thank you!

 

[cjarollins]

Once the data was entered, we got a run time code 13 error. The amount to credit was not correct.

 

[mumps]

I believe that the macro was working properly in the file I posted. Can you upload the version of the file that is giving you the error including the data you entered?

 

[cjarollins]

https://www.dropbox.com/s/krn4t8eqnue3atz/RGA Return-Credit Info Sheet.xlsm?dl=0
Link to the file through Dropbox

 

[mumps]

There was a problem with another merged cell and I also corrected a small error in the code. Click here for your file.