Simple Excel macro/VB code needed to read well-formatted source file containing the following data fields (a) document # (b) GL account (c) Fund # (d) dept # and debit and credit columns. The source system generating the file sometimes "rounds" by a cent throwing a document out of balance. The macro needs to read the data and, when it finds a document out of balance, balance the debits and credits. Written -- detailed -- specs are available with sample data, logic to apply, and sample results.
14 freelanceria on tarjonnut keskimäärin 68 $ tähän työhön
Hi, we have more than 7 years experience in providing solutions in Microsoft Excel. We would be glad to take up your project. Kindly check your PMB for further details.
Hi, Ready to start your project. Please look at my website [url removed, login to view] for my previous works, Bonus money winning projects, my Clients. Lets start.. Regards, Naveen
Need to read a source file and calculate the debit and credit of the file if both are not balanced then need to balance the debit and credit through the macro