Dibatalkan

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.

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.

Kemahiran: Excel, Visual Basic, Pemprosesan Data

Lihat lagi: 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

Tentang Majikan:
( 5 ulasan ) Birmingham, United States

ID Projek: #21360642

66 pekerja bebas membida secara purata $115 untuk pekerjaan ini

jaylancer43

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 freelancer.com and have been featured by the freelancer community (goo.g Lagi

$222 USD dalam 2 hari
(725 Ulasan)
8.5
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 Lagi

$160 USD dalam 2 hari
(333 Ulasan)
7.9
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 Lagi

$250 USD dalam 3 hari
(142 Ulasan)
7.8
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 Lagi

$185 USD dalam 4 hari
(120 Ulasan)
7.3
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 dalam 2 hari
(317 Ulasan)
7.3
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 Lagi

$80 USD dalam 3 hari
(455 Ulasan)
7.5
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 Lagi

$120 USD dalam 3 hari
(224 Ulasan)
7.4
zExcel

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

$99 USD dalam sehari
(261 Ulasan)
7.7
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 Lagi

$30 USD dalam 4 hari
(229 Ulasan)
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 Lagi

$40 USD dalam 2 hari
(191 Ulasan)
6.9
paulmd369

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

$30 USD dalam 2 hari
(119 Ulasan)
6.5
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 Lagi

$150 USD dalam 5 hari
(91 Ulasan)
6.5
MohsanEijaz

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

$250 USD dalam 3 hari
(87 Ulasan)
6.3
wsh2

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 Lagi

$178 USD dalam 7 hari
(52 Ulasan)
6.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 dalam 2 hari
(149 Ulasan)
6.5
polarjin2017

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] Lagi

$155 USD dalam 3 hari
(95 Ulasan)
6.7
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 Lagi

$100 USD dalam 2 hari
(137 Ulasan)
5.9
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 dalam 7 hari
(82 Ulasan)
6.3
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 Lagi

$45 USD dalam sehari
(65 Ulasan)
5.7
aubrey03

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] Lagi

$150 USD dalam sehari
(120 Ulasan)
5.9