En curso

VBA macro for search and filtering

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.

Habilidades: PHP, Arquitectura de software

Ver más: search list names phone numbers, vba macro zillow zestimate lookup reverse phone lookup, list names search phone numbers, macro vba vlookupdynamic file names, outlook macro vba phone number, database names phone numbers, project 2007 html export macro vba, learning use cell phone, use cell phone trunk asterisk, ftp download file macro vba, use cell phone asterisk trunk, excel macro format phone numbers, verification phone numbers use, create search database business phone numbers

Información del empleador:
( 11 comentarios ) Paris, France

ID de proyecto: #11842678

Adjudicado a:

vkalach

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 e Más

€40 EUR en 0 días
(7 comentarios)
3.9

9 los freelancers están ofertando un promedio de €111 para este trabajo.

eagleblackdesign

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 a Más

€200 EUR en 1 día
(34 comentarios)
6.7
espsofttech

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. Más

€157 EUR en 3 días
(91 comentarios)
6.4
sonarkaushik

’*** 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 Más

€89 EUR en 3 días
(37 comentarios)
5.5
kawalecove

We Believe in Quality and Delivering a Quality Product Thanks for your post on freelancer! Ecove Solutions is a trusted, global provider of digital marketing Services and IT Services; our clients rely us due to fastest Más

€100 EUR en 3 días
(12 comentarios)
3.1
schoudhary1553

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 ex Más

€40 EUR en 2 días
(2 comentarios)
1.7
sergeyfishbein

Hi! I have a great experience with Powershell, VBA, C# and Office programming and I would like to take this project

€40 EUR en 3 días
(0 comentarios)
0.0
€111 EUR en 1 día
(0 comentarios)
0.0
mmcfadden93

A proposal has not yet been provided

€222 EUR en 2 días
(0 comentarios)
0.0