Find Jobs
Hire Freelancers

Need an Excel Worksheet built with Multiple conditions and filters.

$30-250 USD

Törölve
Kiadva ekkor: több mint 4 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
I'm looking to get a worksheet that will lookup & retrieve data from multiple sheets/tabs within one excel file. This will require multi-sheet & multi-column lookup with conditions with a return from a corresponding column. Summary page would need mulitple drop down menus for the search condition, date range selection, totals for a condition, a percentage caluculator, and also a filter for the employee's name or number. Example: Summary page would filter by a Work Order type "SC", date range range of 9/1/19 thru 9/2/19, total hours for Work Orders coded as "SC", total hours for the returned value for the "SC" Work Orders divided by the total hours for that date range, and also a filter for an employee name - John Doe.
Projektazonosító: 21360642

A projektről

60 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
60 szabadúszó adott átlagosan $117 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$160 USD 2 napon belül
4,9 (457 értékelés)
8,3
8,3
Felhasználó avatár
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan
$100 USD 2 napon belül
5,0 (555 értékelés)
7,9
7,9
Felhasználó avatár
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD 2 napon belül
5,0 (487 értékelés)
8,0
8,0
Felhasználó avatár
Dear Client I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile for an insight into the quality of my services. I have reviewed your job and ready to proceed, I am quite experienced for such jobs and good in lookup and writing VBA code to calculate the things on the fly along with in cell formulae. Will be looking forward to working with you. Warm Regards Ali
$250 USD 3 napon belül
4,9 (183 értékelés)
8,1
8,1
Felhasználó avatár
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will filter your results based on a combination of filters. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $120* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 330 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$120 USD 3 napon belül
4,9 (389 értékelés)
8,1
8,1
Felhasználó avatár
Dear Hiring Manager, I have read through your project description. I am ready to do some free sample for you. Message me so we can discuss more. You may see my profile here: https://www.freelancer.com/u/motiur03.html I have completed successfully over 700 projects in freelancer.com. I have an Advanced level of knowledge and experience in a similar job, so I can handle this project accurately. Best Regards Motiur
$30 USD 4 napon belül
4,9 (275 értékelés)
7,9
7,9
Felhasználó avatár
Dear Employer , I will design Excel sheet with Advanced formulas, VBA macros if required. I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and completed 400+ projects. Check my reviews to confirm my work quality With Regards, Sai
$80 USD 3 napon belül
4,9 (476 értékelés)
7,7
7,7
Felhasználó avatár
I'm offering to complete this job in 1 day for $99. If you're interested let me know. . .
$99 USD 1 napon belül
4,9 (261 értékelés)
7,7
7,7
Felhasználó avatár
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$185 USD 4 napon belül
4,9 (165 értékelés)
7,8
7,8
Felhasználó avatár
Hi, I have understand the project requirement & interested to do vlookup & filter for this project. Please send a message so we can discuss more & start the project. Thanks.
$30 USD 1 napon belül
5,0 (355 értékelés)
7,3
7,3
Felhasználó avatár
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the input file and I will add a Summary Sheet as per design requirements. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$40 USD 2 napon belül
5,0 (229 értékelés)
7,1
7,1
Felhasználó avatár
Hello there, I am an Excel expert and I can create 1 Excel with VBA script to allow you do as your description. It will be userform with multiple box for filter. Estimate time for complete is 1 day that mean u can get result tomorrow. Please contact me then we can go further. Thank you.
$100 USD 2 napon belül
5,0 (233 értékelés)
6,6
6,6
Felhasználó avatár
I am excel and vba expert, I can write any function in excel. I can create desired spreadsheet for you. Malik
$250 USD 3 napon belül
5,0 (98 értékelés)
6,6
6,6
Felhasználó avatár
Sir,,,,,,,,,,,,,, Could you select me? I will give an excellent results. Hope you will chat with me. thanks
$30 USD 2 napon belül
5,0 (135 értékelés)
6,6
6,6
Felhasználó avatár
$ 30 Only ------- In just 6 Hours ------- Excel VBA Macro & Formula Expert ------- 100% satisfaction first, then payment.
$30 USD 1 napon belül
5,0 (319 értékelés)
6,6
6,6
Felhasználó avatár
Hi there, I am an Excel expert with over 17 years of experience and I would love the opportunity to take a look at the existing raw/source data to determine the best way to model out the retrieval/search tool. The specifications and functionality that you have listed make perfect sense and I would be able to add/program them so you have these filter abilities at the top of the sheet and the filtered data would populate the table below. Slicers might work well for this, and/or some IF logic/functions to automate the filtering of data based on the main filters you require. Hopefully we can work together! Thanks either way for your consideration, Shaun
$150 USD 5 napon belül
5,0 (93 értékelés)
6,7
6,7
Felhasználó avatár
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
$90 USD 7 napon belül
4,7 (85 értékelés)
6,6
6,6
Felhasználó avatár
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your project.
$45 USD 1 napon belül
4,9 (110 értékelés)
6,2
6,2
Felhasználó avatár
Hi. Great app writer for your projects. I have writen excel, csv, database app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$80 USD 3 napon belül
4,9 (132 értékelés)
6,1
6,1
Felhasználó avatár
Hello, I have sound excel experience in creating rather complex formulas and I have worked on similar projects to what you are looking for. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan
$200 USD 7 napon belül
5,0 (19 értékelés)
6,1
6,1

Az ügyfélről

UNITED STATES zászlója
Birmingham, United States
5,0
5
Fizetési mód hitelesítve
Tagság kezdete: szept. 4, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.