VBA - Add autofilters to spreadsheet to narrow data range produced in output file

$30-250 USD

Færdiggjort

Slået op

over 1 år siden

$30-250 USD

Betales ved levering

There are 3 files that currently work together to filter data and produce results. "v3Updated current [login to view URL]" - Initial filter file. Results are produced in cells "EN195:FA2658" "[login to view URL]" - Indicates which filters from the "v3Updated current [login to view URL]" to filter "aapl [login to view URL]" - Results from cells "EN195:FA2658" of the "v3Updated current [login to view URL]" file are pasted to this file. Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added. These 3 filters correspond to the same columns in the "EN195:FA2658" results. "TYPE" and "COND" filters should be dropdown menus where I can select any number of the items and items that match those that should be produced in the "aapl [login to view URL]" file. "OCCUR" should filter based on a "MAX" and "MIN" value placed in cells EP2 AND EP3 of the "v3Updated current [login to view URL]" file.

Excel

Visual Basic

Visual Basic for Apps

Data Processing

Projekt-ID: 34842546

Om projektet

39 forslag

Projekt på afstand

Aktiv 2 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@rumarahman

$0 USD på 2 dage

4,9

(74 anmeldelser)

5,8

39 freelancere byder i gennemsnit $133 USD på dette job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep

$220 USD på 5 dage

4,9

(569 anmeldelser)

8,5

@daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.

$50 USD på 1 dag

4,8

(216 anmeldelser)

7,2

@SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.

$150 USD på 3 dage

4,9

(129 anmeldelser)

6,6

@NIKITALILA

Hi there, I can definitely help you with your Excel work. We can do a quick zoom meeting to understand your requirements better. We are a team of trained professionals with years of experience in Bookkeeping, MS Excel, data entry and are fluent in English. Hit us up and we can talk in detail Regards, Nikita and her team at Affiliazion (V)

$149 USD på 7 dage

5,0

(50 anmeldelser)

6,6

@Devrits

Hello! I am skilled VBA software engineer with skills including Data Processing, Visual Basic, Excel and Visual Basic for Apps. I am Database/VBA/SQL Developer Master of Computer Science with 25+ years experience. Database Development: Backend & Frontend, SQL, query profiling, VBA. MS Access, SQL Server, MySQL, PostgreSQL. Developing and supporting DB for Finance/Accountancy, DM, CRM, ERP, ETL etc. MS Office automation: Access/Exce/Word/Outlook. Macros, VBA, API integration. Google Docs automation. System administration tools for Linux using bash, ruby. Data syncing, encryption, automation. The key focus is to deliver time-saving, user friendly and easy to use applications. Please send a message to discuss more about this project. Thanks

$250 USD på 2 dage

4,9

(70 anmeldelser)

6,3

@zu02

Hi I'll code it just on high level providing all filters automation. Best, from Zurab Access/Excel/VBA/SQL Guru from Georgia

$500 USD på 5 dage

4,8

(50 anmeldelser)

6,2

@Logo199

Hi Rony here I am professional MS OFFICE expert and i know VBA and Macros well. I hope i could deliver exactly what you are looking for. Ready to chat now so we can discuss about the project more Thank you

$250 USD på 3 dage

5,0

(94 anmeldelser)

6,0

@CanguruWorkana

Hello dear Riverside customer, you will get from me a thorough and correct work on building filters using drop-down menus. I've been doing this kind of work for many years and I'm an expert. My ratings are excellent.

$195 USD på 2 dage

4,9

(13 anmeldelser)

5,9

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$90 USD på 3 dage

4,8

(142 anmeldelser)

6,2

@raoarslan56

Hi! I have checked your attached excel file and read your job description carefully! I have understood your requirement clearly!. I would like to create you macro to filter the record based on multiple selected options/criteria using dropdown. I can start working immediately. I would take a day to get this job done.. Text me to discuss more.

$100 USD på 1 dag

5,0

(38 anmeldelser)

5,5

@MamukaB

Hello I can help with this project. I have read explanation. Can do within hour or two. Have some questions regarding details. I have 15+ year experience in Excel, Excel VBA, Python and have 100% feedback So, you can trust to me. Result will be excellent Best Regards

$55 USD på 1 dag

5,0

(63 anmeldelser)

5,3

@carina0530

Hello, I'm fullstack expert, with over 10 years experience dealing with web, I can help add autofilter by excel macro. I will use range and validation features in vba script. I've previously worked on the exact similar project for American Rudy employer. When do you need this finished by? I understand how annoying it is, and can finish this project for you quickly! Please send me message, so i am hoping to discuss with you for this project. Waiting for your reply. Best regards. Carina

$140 USD på 2 dage

4,9

(5 anmeldelser)

4,8

@muzammil21

I've carefully checked your project and really interested in this job. Can you send me a message? Then we can discuss the details and build a long term & healthy business relationship with each other.i have read all Job description in detail. Please consider me for this task and check in my profile all Relevant Skills and Experience. Quality results and satisfied customers are my main priorities. King Regard

$140 USD på 7 dage

3,9

(34 anmeldelser)

6,2

@EmiliaSimon

Hello, I can add filters to your spreadsheet. I am a VBA Developer with extensive experience in Excel automation, and I can quickly and easily deliver the results you need. Please feel free to contact me for any additional details. Thank you a lot. Best regards, Emilia

$55 USD på 2 dage

5,0

(23 anmeldelser)

4,7

@amokhtar70

Hi, I have gone through the project description and am interested in taking it up and I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I have over 25 years of experience supporting systems and users in the information technology field. I’ve been working with MS Excel since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I would be happy if we connect to talk more about your project and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein

$100 USD på 7 dage

5,0

(17 anmeldelser)

4,5

@anenkovakateryna

Hi I have 5 years of experience in <<< Excel macro >>>, so I became an expert that fits perfectly with your requirement fields. I've read the project description carefully and can start work immediately. ✓ Looking forward to hearing more about your project via chat. Best regards!

$100 USD på 2 dage

4,5

(17 anmeldelser)

5,0

@solutionsocean

Hi, I am super expert in excel vba macros and excel automation with more than 15 years of experience, you can expect high quality work from me. regards

$120 USD på 1 dag

4,9

(16 anmeldelser)

4,1

@NANSAMEERA86

Hi Sir. I read your requiemrent and I can do this project. I am a professional Excel VBA developer, writing advance Excel formulas, Creating customized templates to automate repetitive tasks, developing dashboard and reports using Excel and Power BI. I have more than 10 years of working experince using Excel VBA and Maros I am looking forward to having further discussions with you and can start working immediately. please see my profile https://www.freelancer.com/u/NANSAMEERA86 Thank you Sameera

$30 USD på 1 dag

5,0

(29 anmeldelser)

4,1

@tranloanhanu

Hello, I have rich experience in VBA programming. I have read all your explanations carefully and fully understand your requirements. So I am sure I can give you correct and good results. I would appreciate it if you could contact me soon and share your project details. Thank you.

$100 USD på 2 dage

5,0

(5 anmeldelser)

4,0

@sikandarasif

Hi there, Your VBA Specialist is here Graduated from London; United Kingdom in Investment & Finance; Risk Management. I have done various VLOOKUPS, Macros, Data Analysis, Sorting of data, VBA, Hyperlinks and etc. I have handled various excel projects such as Financial Modeling, Risk Assessment, Balance sheet, Income Statements, Data Sorting and etc. I will be able to complete your task as per your requirement and understandings Feel free to inbox for more details and budget Regards, SA

$100 USD på 2 dage