Need an Excel Worksheet built with Multiple conditions and filters.

Peruttu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Peruttu Maksettu toimituksen yhteydessä

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.

Excel Visual Basic Tietojenkäsittely

Projektin tunnus: #21360642

Tietoa projektista

60 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

60 freelanceria on tarjonnut keskimäärin $117 tähän työhön

schoudhary1553

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 Lisää

$160 USD 2 päivässä
(457 arvostelua)
8.3
asadkhan3533

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 päivässä
(555 arvostelua)
7.9
P0L

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 päivässä
(487 arvostelua)
8.0
Eagles90

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 Lisää

$250 USD 3 päivässä
(183 arvostelua)
8.1
paris2785

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 Lisää

$120 USD 3 päivässä
(389 arvostelua)
8.1
motiur03

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 Lisää

$30 USD 4 päivässä
(275 arvostelua)
7.9
SBITServices

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 Lisää

$80 USD 3 päivässä
(476 arvostelua)
7.7
zExcel

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

$99 USD 1 päivässä
(261 arvostelua)
7.7
zekovicm

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 Lisää

$185 USD 4 päivässä
(165 arvostelua)
7.8
rashedkhanrubel

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 päivässä
(355 arvostelua)
7.3
ksriniravi

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 Lisää

$40 USD 2 päivässä
(229 arvostelua)
7.1
nvchien94

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 Lisää

$100 USD 2 päivässä
(233 arvostelua)
6.6
MohsanEijaz

I am excel and vba expert, I can write any function in excel. I can create desired spreadsheet for you. Malik

$250 USD 3 päivässä
(98 arvostelua)
6.6
paulmd369

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

$30 USD 2 päivässä
(135 arvostelua)
6.6
AnowarRatul

$ 30 Only ------- In just 6 Hours ------- Excel VBA Macro & Formula Expert ------- 100% satisfaction first, then payment.

$30 USD 1 päivässä
(319 arvostelua)
6.6
ShaunKleinOnline

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 Lisää

$150 USD 5 päivässä
(93 arvostelua)
6.7
seoguru17

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 päivässä
(85 arvostelua)
6.6
c4cuteconain

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 pr Lisää

$45 USD 1 päivässä
(110 arvostelua)
6.2
writingapp

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 päivässä
(132 arvostelua)
6.1
razvancotofana

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. Lisää

$200 USD 7 päivässä
(19 arvostelua)
6.1