I appreciate you working with me. I apologize if I am not answering your questions correctly. I am not sure the best way to get this done. I like that way I have since it has worked for years. I use these conversion files for 7 other distributors that I receive raw data from. I like the way I have it now because it is easy to modify when I get data from a new source. Each source gives me data a different way.
From the raw data I receive I always just need the date, number, customer, item, qty and sometimes price. I only need price when it is from a distributor that gets discounts. Not all of them do. Since I have the excel sheets the macros references to convert their customer names and item numbers to match what I need in my accounting program it is easy to convert the process when I receive data in a new format.
If you know of a better way to complete the process I am all about it. I did not explain I use this process for many other distributors raw data. Maybe I should have.
I am open to any options that will work. Currently I will copy the data I need from the raw data, paste it into my conversion file and run the main macro. Then I just save the file and upload it into the accounting program.
As I said I am open to any way to change their raw data into a matching format. I was just thinking if I could have one macro to create the creditt numbers like I explained above that would be easiest then I can keep the reset of the process the same.
The data I get from my ERP program will be the only raw data I need to fix the credit numbers.
I attached an excel file that has 6 sheets. Each sheet is raw data I receive from different distributors. They data comes in different order and also include a lot of data I don't need. I just pick out the columns I need then do the conversions.
I will be getting more raw data from other distributors soon also.
A couple facts I should explain about the uploading process.
The converted data needs to be in two different excel files. One with credits and one with invoices. It must be an xlsx file with only one sheet.
I am guessing the way I have things are a mess. I have had different people help at different times. I have had experts do some and then I have also modified some macros on my own. When I have done it was a lot of trail and error. I have never used excel macros before last year. I was a network engineer who worked on the road at different business then I took the current job I have now. I do little of everything here. I like the challenge at times. Excel has never been a strong point of mine. So I can guess the conversion files are probably not efficient and a mess.
Reply With Quote