Thank you. I will look into the code you have tomorrow. These are delivery sheets. Some are for the items we delivered and also for the returns. The one I attached in my last reply is a single module that will do all the conversions For the delivery sheet. The other one I need is for returns So my macro converts the negative numbers to positive numbers so I can import them into my accounting system. They need to be imported as positive numbers. Thank you for all the suggestions. I will look more tomorrow

The delivery item only requires me to import one file. The one included in my last reply For the return process I need to import many different files in order to run the main one.

For now I do have one. It does run “call” of them just by running one macro. But you need to import six different files so they are all there. That is for the returns. For the delivery items I was able to combine all of them into one. Where you only need to import one file and there is only one option to click run in the macro box I’m not sure if I’m making sense but I am using voice text from my phone. I will take a look tomorrow and clarify if I need. Again thanks