Narrative Tagging Macro in Excel

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

We are looking for a macro that can scan narratives in excel for key words. When it finds certain key words, it is able to pull an ID number from the narrative and the tag associated with the key word(s) and put those in an output table.

Pseudo code and excel structure is provided. Please note that this is not the data set we need this macro for, but a fake data set that mimics the actual data set in structure.

UPDATE: We need the macro to loop through two columns of narratives, and add KeywordID to the Output Table.

I have attached new source documents with these updates (dated October 20th in document name)

Data Entry Data Mining Data Processing Excel Visual Basic

Project ID: #11839342

About the project

17 proposals Remote project Active 7 years ago

Awarded to:

cgullapalli

Hi, I am good at Excel and vba. I have referred the files. I got the requirement with the clear instructions provided. Hope u r using Windows OS and would like to know the version of the excel. Looking forward to di More

$54 USD in 0 days
(961 Reviews)
8.1

17 freelancers are bidding on average $69 for this job

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 o More

$30 USD in 1 day
(395 Reviews)
8.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y More

$34 USD in 1 day
(268 Reviews)
7.6
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

$40 USD in 1 day
(214 Reviews)
6.9
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only.

$35 USD in 1 day
(263 Reviews)
6.5
katilinas

Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$55 USD in 3 days
(120 Reviews)
6.6
diorisaguilar

I have checked your request and I know how to accomplish this task. I can place a button in the output tab to start the process and I can put a progress bar to let you know the progress of the calculation. I just check More

$50 USD in 1 day
(52 Reviews)
6.2
dpune

Hi, I have reviewed revised attachments and I am comfortable creating macro for the same. I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 280 proje More

$140 USD in 3 days
(181 Reviews)
6.5
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. You press a button and receive a report. I can start today. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$55 USD in 3 days
(99 Reviews)
6.1
mepanku

hello, Expert in excel and willing to work for you. Please send me more details and I will start right now. thanks

$66 USD in 1 day
(21 Reviews)
4.1
bluespider12

Hello! I have extensive experience with Microsoft Excel, inducing building macros. At Lockheed Martin, I have created macros to fill complex spreadsheets with thousands of rows of data to analyze. I am highly focused, More

$222 USD in 3 days
(0 Reviews)
0.0
brianoneill1

Hi, I am new to the site and I'm keen to build up my profile. So I'm willing to do this at a low price and turn it around quickly if I am accepted. I have been working in the finance industry for over 12 years and I am More

$30 USD in 2 days
(0 Reviews)
0.0
meeshusoft1

Hi. This can be easily accomplished. However, please clarify following before awarding (this will not project cost quoted by me but it will give you a correct product as per your requirements): 1. Keyword2 and Keywo More

$70 USD in 1 day
(0 Reviews)
0.0