Excel Macro
₹1500-12500 INR
Dibayar saat pengiriman
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 Proyek: #17248758
Tentang proyek
Diberikan kepada:
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 Lebih banyak
21 freelancer rata-rata menawar ₹6243 untuk pekerjaan ini
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
Hi - I am an IT professional with 2 decades of experience in Infosys. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can hand Lebih banyak
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.
Hi, I went through the sample you provided. I have prepared similar sheets earlier and will be able to do this for you. I will need a discussion over skype just to validate my understanding of the requirement. And m Lebih banyak
