Excel Macro
₹1500-12500 INR
Оплачується при отриманні
I am sharing a excel sheet Task
(1-) Data for task 1
Create macro for expected result for data 1
when we take entry of date range "deldate" and click on macro button then it pull the related information from sheet "Data for task 1"
Expected result for task 1:----
(a-) Yellow column is important for result...
(b-) this is example of jobsite 1 but we have to create all the cancelled order volume for all job site which is 3
In yellow column of order volume for jobsite 1
here is 45 order volume cancelled and frequency is 30 minutes its mean
that 8 is capacity of truck load then after 30 minutes another 8 truck is loaded then after 30 minutes another 8 truck is loaded and so on.....
45=8+8+8+8+8+5
you can see this example in expected result sheet
(2-) Data for task 2
explaining with example:---
sheet 2 is pivot table you can calculate the value from here
I have to make a macro button on expected result for task 2
delivery time changed by customer and cemex. Explaining with example
5 jobsite
18 orders
See DOC----7
job of related site ---4
time duration:---New value- old value
Below a another macro button is here which calculate the dilated discussion of each job site.....
ID Проекту: #17248758
Про проект
Доручено:
Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Більше
21 фрілансерів(-и) готові виконати цю роботу у середньому за ₹6243
Hi there..... Warm Greetings We came along with your request for Excel Macro and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals Більше
ello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicati Більше
I have excellent command on MS Excel and can create the macros as per your requirement. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and plac Більше
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes Більше
Hi I am an excel vba expert and I went through your project description in detail. I’ve done many jobs like these. Please go through my profile and reviews so that you can be confident in my abilities. Hope to chat w Більше
I am VBA expert with 9+ years of experience. I can provide you fast results with 100% perfection level. You can fully trust my skills on your project. Ping me to see my past experience.