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 [login to view URL] 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

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

Project ID: #11796490

44 freelancers are bidding on average $25 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
(704 Reviews)
7.7
sandroshubladze

Hello, I am audit manager and I know VBA too of course. Feel free to ask any questions before awarding and we can discuss details

$35 CAD in 2 days
(173 Reviews)
7.3
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
(271 Reviews)
7.1
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
(197 Reviews)
6.7
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
(141 Reviews)
6.5
zebracaro

I can do it for you quickly and exactly .

$25 CAD in 1 day
(94 Reviews)
6.4
MoohHHooM

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

$20 CAD in 0 days
(26 Reviews)
5.3
$25 CAD in 1 day
(28 Reviews)
5.6
osmemon

5 Years of Experience. Highly competitive team. Hire us for best and accurate results of your projects

$30 CAD in 1 day
(34 Reviews)
5.6
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
(44 Reviews)
5.9
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
(61 Reviews)
5.6
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
(29 Reviews)
4.9
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
(52 Reviews)
5.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
(46 Reviews)
4.7
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
(21 Reviews)
4.5
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for th More

$25 CAD in 1 day
(7 Reviews)
4.4
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
(18 Reviews)
4.3
$20 CAD in 1 day
(60 Reviews)
4.4
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
vivirain

Hi, I'm interested in the job. I have rick experiences in Excel VBA/Macro programming and can help complete the job well. Look forward to hearing from you soon. Best Regards,

$20 CAD in 1 day
(10 Reviews)
3.7