Closed

Need a VBA macro done which searches data with userform and different conditions

I have two types of data in the spreadsheet, the first is contained in column A, and the other type in the rest of the [url removed, login to view] row going down in column A is a tag. If you go across the row you can see which tags from a different server are linked to it. I want a macro that allows users to do the following a userform:

a) if someone searches a tag from from column A they get all the other tags from the other columns, going from left to right

b) if someone searches a tag from the other columns get the tag from column A that matches it

Skills: Data Processing, Excel

See more: sort data cell vba macro word, excel columns text file macro, columns text macro, vba macro download data website, vba macro data excel word, vba macro data entry txt file, vba macro code accept data entry, read webpage data excel vba macro, macro columns text excel, excel macro vba import csv text file, delete data clipboard vba macro, add name different columns vba macro, find text powerpoint using macro vba, vba macro paste excel data, excel vba macro download yahoo stock data, inputting multiple data vba macro, excel vba macro copy columns data, download historical stock data excel vba macro, macro vba file text word, excel 2007 macro vba update, vba macro cut data spreadsheet spreadsheet, outlook macro vba phone number, vba macro show data, macro vba institute bangalore, columns text joomla

About the Employer:
( 2 reviews ) St. John's, Canada

Project ID: #11796490

46 freelancers are bidding on average $27 for this job

cgullapalli

Hi, I am good at Excel and vba. I have referred the excel file. Looking forward to discuss in the chat.

$50 CAD in 0 days
(272 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$50 CAD in 1 day
(136 Reviews)
6.5
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.

$50 CAD in 1 day
(106 Reviews)
6.2
zebracaro

I can do it for you quickly and exactly .

$25 CAD in 1 day
(68 Reviews)
5.5
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$35 CAD in 1 day
(47 Reviews)
5.2
$25 CAD in 1 day
(25 Reviews)
5.4
$20 CAD in 1 day
(53 Reviews)
4.3
Iwin

Hello, I have very good experience with VB/VBA programming and MS Office Application Automation, including MS Excel. I have also completed several VBA projects here Quick turnaround guaranteed Ola

$15 CAD in 1 day
(12 Reviews)
4.1
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your ins More

$30 CAD in 1 day
(31 Reviews)
4.2
satishtl

-Can search for the tags in other columns or the linked servers. - Or based linked server bring in the main server from Col A. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Gra More

$15 CAD in 1 day
(22 Reviews)
4.2
MoohHHooM

I am ready for this project, please let me more about your requirement. More

$20 CAD in 0 days
(7 Reviews)
4.3
serdaryalcin

Hello, What do you mean with search? Is it OK if only a part of it matches with the result? I can put a textbox and a search button. When the button is pressed, the results matching would be put in another Listbo More

$30 CAD in 1 day
(19 Reviews)
4.2
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$20 CAD in 1 day
(23 Reviews)
4.2
teeares

I have created many macros in Excel. I can do this one also.I would like to know how you will be inputting the tags. Presumably you want case also matched. All that you require is an input box to enter the tag and a m More

$15 CAD in 1 day
(46 Reviews)
4.8
rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Data Processing Data Collecting (Using Macro) MS Office C++ More

$50 CAD in 1 day
(9 Reviews)
4.0
customizedata

I have downloaded the sheet. It has only one column i-e A...Please message me so that i could clarify the requirements with you

$30 CAD in 1 day
(12 Reviews)
4.0
roamabdul

Hello sir, I have downloaded and checked your file and fully understood your needs for this projects. I have been working for almost 10 years on Excel and have a great knowledge and experience in Excel automation us More

$20 CAD in 1 day
(4 Reviews)
3.5
excel4engineers

Thanks for your clear instructions. You can get it today. I will provide you VBA macro which will be able to process any number of rows and any number of tags per each cell with one click.

$15 CAD in 1 day
(12 Reviews)
3.6
ksinghrajeev

Hi, As I understand this is OSI PI tags and you want to search the tags mapped to which server and based on server, what all tags are present. Please allocate this project to me if you are ok with my bid and shar More

$50 CAD in 5 days
(3 Reviews)
3.3
shivaparvathi108

Dear Employer, I have gone through the requirements. I am good at excel VBA macro. I think it is doable only. I can complete this work easily. Let me know when we shall start work on it.

$15 CAD in 1 day
(21 Reviews)
3.7