Create Macro & Report (pivot table)
$10-30 USD
Paid on delivery
Create a macro that will calculate commission based on state, company tier and product category. Each company tier has a different commission rate.
copy data from data tab to commission tab
filter and display only the applicable states
determine the tier of the customer (Tier 0 = excluded company, Tier 1 (see chart), Tier 2 = remaining companies)
examine the product category and apply the tier commission rate to calculate the commission for each line in the data tab.
see instruction sheet tab
An example of a real file is attached
I'd like to have the macro written tested within 48 hours. Target price is $20
Project ID: #6696791
About the project
Awarded to:
Hi, all is clear and I can code the macro in the next hours. Thanks **************************************************
5 freelancers are bidding on average $23 for this job
Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job.
"We are a professionally specialized Web design and Development Company. We provide a wide range of affordable Internet- Related outsourcing services to our clients all around the globe. With our wide ranging exper More
Dear sir I see your project and i do it as your acceptation. I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO and Photoshop work would like to assure you that I will do More
Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, M More