Find Jobs
Hire Freelancers

VBA macro for search and filtering

€30-250 EUR

Imekamilika
Imechapishwa over 7 years ago

€30-250 EUR

Kulipwa wakati wa kufikishwa
Purpose is to build a macro that returns data based on a search string. 1 Search Sheet 1 Data Sheet. Example Fields : Company, Name, Sirname, Phone, Email, Comments 1/ In a cell af Search sheet, input strings to be searched. 2/ Search all cells of line 1 of the Data sheet for the searched strings If string is found in any cell of Line 1 of Data sheet Then Return the Data in Search sheet Else Search all cells of line 2 etc until end of data in Data sheet Specials : 1. Macro must allow for multiple string search with boolean operators (example : Robert + John will search each cell and return the data for all the Roberts and Johns of the Data Sheet) 2. Macro must allow for a large number of fields in the Data Sheet. Its fine if this needs the user to modify the source code a little 3. Macro must allow for a selected number of fields to be returned in the Search sheet. Example : only return names and phone numbers. Also fine if this requires the user to modify the code a little. 4. We want the returned data to be coded in form Cell (r, c) in Search Sheet = Cell (a,b) of Data Sheet. ie we don't want the code to be in a form "if data found in a line of Data Sheet, just copy paste line in Result Sheet). This will allow us to return just the few required fileds if needed and be returned in another relative position if need be. 5. Coding is clean, with lines of comment 5. Code is accessible to view, modify and re-use We are reasonnably VBA litterate and aware that this is very simple coding (10 to 20 lines or so / 1 or 2 hrs work) for any one mastering VBA. Hence bids are expected to be in line.
Kitambulisho cha mradi: 11842678

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 7 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi I have a ready-made solution . I update this solution for you I have an Excel macro which does the following: we have many spreadsheets, as many as 100, with lists of names, work titles, work department and email. The macro needs to find certain keywords in one of two columns (it must search both columns) and then select the complete record and export it to a separate spreadsheet. We need to be able to find a range of keywords. For example we might say, find all records with any of the following words in the specified columns: biology, medicine, pediatrics, psychiatry, healthcare, etc. etc. We also want an exclusion feature if possible. For example, we would like to say, find records with any of the keywords listed but exclude records with the following terms: part-time, consultant, adjunct, etc etc. Finally, we want the macro to search one spreadsheet after another and so we need some form of panel to specify which spreadsheets to search. All of the spreadsheets can be in one directory if this helps. Most single spreadsheets are a few thousand records but some are as large as 10,000. [login to view URL] Sincerely, Vladimir https://www.freelancer.com/u/vkalach.html [login to view URL]
€40 EUR ndani ya siku 0
5.0 (7 hakiki)
3.9
3.9
9 wafanyakazi huru wana zabuni kwa wastani €111 EUR kwa kazi hii
Picha ya Mtumiaji
Hello Wish you are well I have gone through your project requirement.I can do this work with perfection as per your requirement. you need VBA macro for search and filtering. 1 Search Sheet 1 Data Sheet. I have more then 7 year experience in development. You can check my review. I am here to communicate with you in your timezone and i assure you will get your work with very professional way with me. Please open your massage box and massage me so we can discuss more and I can show you my previous work. I am waiting your positive reply. Thanks Regard Rahul Bhadouria
€157 EUR ndani ya siku 3
4.9 (91 hakiki)
6.4
6.4
Picha ya Mtumiaji
Hello! We are a professional team of php/mysql/js/html developers. We have huge experience in creating apps and scripts from scratch or modifying existing ones. Please provide more details about your project. We are available and will be happy to help you with the project. Looking forward for further discussion. Best Regards, Sergii Savchenko CEO @ PineDev Studio
€200 EUR ndani ya siku 1
4.9 (34 hakiki)
6.7
6.7
Picha ya Mtumiaji
’*** Note to freelancer staff - wrongly messaged email here - due to some bug and screen fluikering - this message not for this user - rather - it is for for a email reply of my email *** please discard and delete the previous message with email
€89 EUR ndani ya siku 3
4.6 (37 hakiki)
5.5
5.5
Picha ya Mtumiaji
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€40 EUR ndani ya siku 2
5.0 (2 hakiki)
1.7
1.7
Picha ya Mtumiaji
Hi! I have a great experience with Powershell, VBA, C# and Office programming and I would like to take this project
€40 EUR ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
€222 EUR ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya FRANCE
Paris, France
5.0
11
Njia ya malipo imethibitishwa
Mwanachama tangu Okt 27, 2015

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.