Find Jobs
Hire Freelancers

Need an Excel Worksheet built with Multiple conditions and filters.

$30-250 USD

Cancelled
Posted over 4 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 21360642

About the project

60 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
60 freelancers are bidding on average $117 USD for this job
User Avatar
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 in 2 days
4.9 (457 reviews)
8.3
8.3
User Avatar
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 in 2 days
5.0 (555 reviews)
7.9
7.9
User Avatar
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 in 2 days
5.0 (487 reviews)
8.0
8.0
User Avatar
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 in 3 days
4.9 (183 reviews)
8.1
8.1
User Avatar
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 in 3 days
4.9 (389 reviews)
8.1
8.1
User Avatar
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 in 4 days
4.9 (275 reviews)
7.9
7.9
User Avatar
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 in 3 days
4.9 (476 reviews)
7.7
7.7
User Avatar
I'm offering to complete this job in 1 day for $99. If you're interested let me know. . .
$99 USD in 1 day
4.9 (261 reviews)
7.7
7.7
User Avatar
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 in 4 days
4.9 (165 reviews)
7.8
7.8
User Avatar
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 in 1 day
5.0 (355 reviews)
7.3
7.3
User Avatar
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 in 2 days
5.0 (229 reviews)
7.1
7.1
User Avatar
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 in 2 days
5.0 (233 reviews)
6.6
6.6
User Avatar
I am excel and vba expert, I can write any function in excel. I can create desired spreadsheet for you. Malik
$250 USD in 3 days
5.0 (98 reviews)
6.6
6.6
User Avatar
Sir,,,,,,,,,,,,,, Could you select me? I will give an excellent results. Hope you will chat with me. thanks
$30 USD in 2 days
5.0 (135 reviews)
6.6
6.6
User Avatar
$ 30 Only ------- In just 6 Hours ------- Excel VBA Macro & Formula Expert ------- 100% satisfaction first, then payment.
$30 USD in 1 day
5.0 (319 reviews)
6.6
6.6
User Avatar
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 in 5 days
5.0 (93 reviews)
6.7
6.7
User Avatar
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 in 7 days
4.7 (85 reviews)
6.6
6.6
User Avatar
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 in 1 day
4.9 (110 reviews)
6.2
6.2
User Avatar
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 in 3 days
4.9 (132 reviews)
6.1
6.1
User Avatar
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 in 7 days
5.0 (19 reviews)
6.1
6.1

About the client

Flag of UNITED STATES
Birmingham, United States
5.0
5
Payment method verified
Member since Sep 4, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.