Convert Many Invoice Formats to a Standard Format

[joeny0706]

I am not that smart when it comes to VBA. I do currently have a xlsm file. I take the data from the csv and past it into that. I received a lot of help to create that. Mostly people from this site worked with me and wrote the scripts for me. I learned some very simple task but not much.Mostly I just figure out things when I need small changes. So, the attached xlsm files are what I use to convert the data.

Since I do credits and invoice separately, I need to have a different file I use to add the credit note number. Then after the credit note has numbers I then can split the data into the two attached files to convert it to a format I can use to upload into the accounting program.

When I convert the data I need to do credits and invoices separate

Thanks for help but I do not understand any of what you are saying.

I do want to learn but don't plan to use VBA much after this. I am just in need of this soon. If I must I can get the company to pay to have it completed.

I will have hundreds of invoices and credits to import each day. For over 30 routes. I am hoping for a script that can do all the task.
Then I will just run the macro and have it complete everything.

I have created the others but asking for help from others

Each script people have helped me with I do go over and try to learn how it works. This on just has nothing like any of the others. The searching part where it matches date and store name to take that invoice number and move it to the bottom is where I have no clue at all