I apologize if you think I mislead you. I am not sure how you think I did mislead you. I have explained everything I do and also how I got to the point I am at now. I did not have any knowledge with VBA. I was just to able to get help from others and troubleshoot the issues to get it working as is.

That is all I do. I export the data. I then convert the data and upload it. Once I start the upload it takes anywhere from 30 min to 3 hours depending how much data. I don’t do anything during this time besides wait for it to finish. The converting does not take long. As I explained previously, I just copy and paste the data into my xlsm file and run the macro.

You are the one who said my boss should replace me because I said it takes 3 hours. I was just letting you know that part of the process there is no one who can speed it up using the program I do to upload it. I have no complaint that it takes to long. I never said that. I understand with the program I use that is how long it will take.

As I said previous I understand it is alot of work to redo the complete process and would take anyone many hours to fix. I was not looking for that. I would appreciate anyone who is willing to but that is not required. How I do it now is a quick process. It may not be the best way but it is easy and gets it done.

My first issue was the credit numbers. To get that fixed. When you looked at my xlsm file and others I was told it is not correct and not an efficient way to do it. I would appreciate if anyone wanted to help me so I am doing it correct but like I said the way I do it does work fine. I just need to get the credit numbers to be the invoice number with a 9 in front of it. I tried doing what Paul explained but was not able to get it to work. As I said I have very limited knowledge with VBA.