Need an Excel Worksheet built with Multiple conditions and filters.

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.


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.

Skills: Excel, Visual Basic, Data Processing

See more: excel advanced filter contains, excel filter multiple values in one cell, excel filter multiple header rows, excel advanced filter between two dates, excel formula for filter criteria, excel advanced filter multiple criteria, advanced filter excel 2016, excel advanced filter does not contain, excel vba import multiple file worksheet, excel vba sum multiple conditions, excel macros loop multiple conditions, excel macro loop multiple conditions, vba excel loop multiple conditions, vb excel loop multiple conditions, i am looking to build excel sheet contains multiple sheets, i have multiple document that just need to be retyped into word as i need to make changes to them they need to be edited, i need excel data entry, i need excel expert, need computer expert to setup my excel worksheet in mililani hawaii, i need a website built

About the Employer:
( 5 reviews ) Birmingham, United States

Project ID: #21360642

65 freelancers are bidding on average $115 for this job


Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (goo.g More

$222 USD in 2 days
(728 Reviews)

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. Pl More

$160 USD in 2 days
(333 Reviews)

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 More

$250 USD in 3 days
(143 Reviews)

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 More

$185 USD in 4 days
(120 Reviews)

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
(317 Reviews)

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 progra More

$80 USD in 3 days
(455 Reviews)

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 filt More

$120 USD in 3 days
(224 Reviews)

I'm offering to complete this job in 1 day for $99. If you're interested let me know. . .

$99 USD in 1 day
(261 Reviews)

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: More

$30 USD in 4 days
(231 Reviews)

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 requirem More

$40 USD in 2 days
(191 Reviews)

Sir,,,,,,,,,,,,,, Could you select me? I will give an excellent results. Hope you will chat with me. thanks

$30 USD in 2 days
(119 Reviews)

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 spe More

$150 USD in 5 days
(92 Reviews)

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA Business Information, Programming, and Database expert with GURU / MENTOR level technical credentials at www.experts-exch More

$178 USD in 7 days
(52 Reviews)

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
(87 Reviews)

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
(149 Reviews)

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$155 USD in 3 days
(95 Reviews)

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
(82 Reviews)

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 More

$100 USD in 2 days
(138 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$150 USD in 1 day
(121 Reviews)

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. More

$200 USD in 7 days
(16 Reviews)