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

$30-250 USD

완료함

게시됨

1년 이상 전

$30-250 USD

제출할때 지불됩니다

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

프로젝트 ID: 34842546

프로젝트 정보

39 제안서

원격근무 프로젝트

활동 중 2년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@rumarahman

$0 USD 2일에

4.9

(74 건의 리뷰)

5.8

39 이 프로젝트에 프리랜서들의 평균 입찰은 $133 USD입니다.

@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 5일에

4.9

(569 건의 리뷰)

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 1일에

4.8

(216 건의 리뷰)

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 3일에

4.9

(129 건의 리뷰)

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 7일에

5.0

(50 건의 리뷰)

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 2일에

4.9

(70 건의 리뷰)

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 5일에

4.8

(50 건의 리뷰)

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 3일에

5.0

(94 건의 리뷰)

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 2일에

4.9

(13 건의 리뷰)

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 3일에

4.8

(142 건의 리뷰)

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 1일에

5.0

(38 건의 리뷰)

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 1일에

5.0

(63 건의 리뷰)

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 2일에

4.9

(5 건의 리뷰)

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 7일에

3.9

(34 건의 리뷰)

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 2일에

5.0

(23 건의 리뷰)

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 7일에

5.0

(17 건의 리뷰)

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 2일에

4.5

(17 건의 리뷰)

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 1일에

4.9

(16 건의 리뷰)

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 1일에

5.0

(29 건의 리뷰)

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 2일에

5.0

(5 건의 리뷰)

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 2일에