I have attached the export file and then the two xlsmfiles I use to convert the data. Right now, I use these xlsm files daily toconvert data from other sources. I have done it this way for a couple years andworks perfect with data I receive from other distributors. From them the creditand invoice number are already correct.
I am not sure what a complete refactoring is. But thingsare working perfect and have for years for data I receive from otherdistributors. It may not be the best way or most productive but it does the jobwithout any problems.
I convert the invoice data and credit data separatelysince the program I use to upload the data needs it that way. Can only doinvoices or credits. Can’t upload both at the same time. I have attached the two files used to convert the dataalso. In both files I have a runall macro. I paste the data in and run therunall and then I am done. These two I attached have data in them that I would get from theexport file. Those will be used after I change the credit number like I need.Explained below.
In the export file Line 178-186 has the invoice data andlines 188 and 189 are the credit data. What I need to do is create a macro thatwill change column B on line 188 and 189 “the credit number” to match theinvoice number with a 9 in front of it. So the invoice number is 111991. I needcolumn B lines 188 and 189 to say 9111991. Once I run a macro to change thecredit number, I will then split the credit data and the invoice data into thetwo xlsm files to convert it to a format needed to upload into the accountingprogram.
I do need to keep the lines in the order they are. I cantmove them like suggested above since I need to split it “invoice data andcredit data” to convert the data
Reply With Quote