I want to automate 2 reports via VBA Macros as follows
(A) AUTOMATE MONTHLY SALES REPORT ANALYSIS
A monthly sales report. My Report has the following fields (See attached).
My interest is for you to develop a VBA macros script which will automatically on running the script generate the following reports (See attachment)
(1) Sales Revenue Analysis by Centre showing amount paid and amount unpaid orders (2) Sales Count Analysis by Centre showing count of paid and unpaid orders (3) Analysis of Discounts (4) Top 10 customers by revenue and by orders (5) List of customers with unpaid orders (6) List of discounted orders or customers
(B) AUTOMATE REVENUE ASSURANCE EXCEL
I want to validate or confirm the truth for orders indicated as paid in the sales report by looking up a bank statement/reconciliation record and pulling up the date and amount paid in the bank statement into a field on the sales report. Each payment record would be set off against the order amount and it there is a difference it will indicate so. It will also allow for manual intervention for some records.
This is an urgent which i need within a day or 2. Its also one I consider a simple job which I expect would cost low.
I would share all the files with selected freelancer under professional NDA.
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
11 freelancers are bidding on average $60 for this job
Hello, I read your job description and I possess all the necessary skill for this work. I have 16 Years of Experience in Excel VBA. I can complete your project in 1 day. Thanks and Regards Sounak.