Excel Macro - Calculate Average Sales per weekday per customer
$30-250 AUD
Paguhet në dorëzim
NOTE: This macro must be written for the Excel Personal File.
If you do not know what this means, please do not bid.
My accounting system is MYOB.
From this system, I intend to export a sales file covering a number of weeks. Usually 4 but can be more or less
I have a spreadsheet that functions as a MASTER sheet. It contains item codes in the Rows and needs to contain Customer Names in the columns.
In the cells corresponding to customer name and item code, the cell must contain the average sales quantity for that item as calculated from the MYOB sales file.
Requirements:
- Macro must create a new column per week day per customer as dictated by the Sales file.
- Average quantities that result in non-integers must be rounded up the nearest integer
- Items in the Sales file that do not appear in the Master file (if any) must be dealt with elegantly. Perhaps inserting their details at the bottom of the master is best.
-The Master sheet will contain a template customer column for duplication when inserting a new specific customer column.
- The top cell of the customer column (Row 1) must contain an abbreviation of the week day (Mon, Tue, Wed, Thu, Fri, Sat, Sun)
- The second cell of the customer column (Row 2) must contain an abbreviation of the customer name as specified withing the worksheet "shortnames" of the Master file
- Dialog box must show at completion of execution regarding status. I.e. whether all quantities were successfully inserted or if there were problems such as item codes that were not found.
ID Projekti: #18072160
Rreth projektit
Është zgjedhur fitues:
Hello there, thanks for inviting me to bid on your project, I am looking forward to serve you as best as i know how. Thanks again
17 profesionistë freelancer dërguan një ofertë mesatare prej $158 për këtë punë
Hello, Hope you are doing well. I can help with you in your project Excel Macro - Calculate Average Sales per weekday per customer . I can assure you the quality job. I have good experience in Accounting, Dat Më shumë
Hello? How are you? I have good experiences in "Excel Macro - Calculate Average Sales per weekday per customer" as you can see my profile for these (Accounting, Data Entry, Data Processing, Excel, Visual Basic). I h Më shumë
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Më shumë
I am a professional Financial Analyst, Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Fore Më shumë
Sir, I am very able to create this macro flawlessly and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to he Më shumë
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Më shumë
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Më shumë
Hey, I understand your requirements and i am sure i can build this efficient process for you. I am 9 years experienced professional with expert knowledge of data collection, transformation, analysis and visualiz Më shumë