Hello,
I have given details of the job below. I am ready to pay upt 50 $ if the job is done. Please feel free to ask for any clarifications if required. Thanks a lot !
ID #
Business Requirement
Type
Units Affected
Applications
BRQ1234
Every country has its own national animal or bird.
NA
NA
NA
BRQ1235
The country that is known for its wildlife animals is an important country.
NA
NA
NA
BRQ1236
The fruits are often exported from one country to another.
NA
NA
NA
BRQ1237
The animals and fruits are mostly unique for each country.
NA
NA
NA
BRQ1238
Every country has its own national sport
NA
NA
NA
ID #
Business Requirement
Type
Units Affected
Applications
BRQ1241
Every country has its own national animal or bird.
NA
NA
NA
BRQ1242
The country that is known for its wildlife animals is an important country.
NA
NA
NA
BRQ1243
The fruits are often exported from one country to another.
NA
NA
NA
BRQ1244
The animals and fruits are mostly unique for each country.
NA
NA
NA
BRQ1245
Every country has its own national sport
NA
NA
NA
The excel sheet (Input file) acts as a database and is used to map each keyword to a number of other words called checklist. In the word document there are a number of tables like the ones shown above the mapping takes place here in the word document using the excel as a input file.
A macro is written in the word document. Then when the macro is run then the keywords are all highlighted.
So the document looks like this only the macro is run.
ID #
Business Requirement
Type
Units Affected
Applications
BRQ1234
Every country has its own national animal or bird.
NA
NA
NA
BRQ1235
The country that is known for its wildlife animal is an important country.
NA
NA
NA
BRQ1236
The fruits are often exported from one country to another.
NA
NA
NA
BRQ1237
The animals and fruits are mostly unique for each country.
NA
NA
NA
BRQ1238
Every country has its own national sport
NA
NA
NA
ID #
Business Requirement
Type
Units Affected
Applications
BRQ1241
Every country has its own national animal or bird.
NA
NA
NA
BRQ1242
The country that is known for its wildlife animal is an important country.
NA
NA
NA
BRQ1243
The fruits are often exported from one country to another.
NA
NA
NA
BRQ1244
The animals and fruits are mostly unique for each country.
NA
NA
NA
BRQ1245
Every country has its own national sport
NA
NA
NA
Note that the keyword country repeats itself twice for the same BRQ ID. So it needs to be highlighted only once not again.
I have highlighted it in red just to explain. The code need not do it.
After that when the user presses a unique key (say like escape or something) the cursor should go from one keyword to the other.
When the user the clicks on the highlighted keyword it should display the set of check listed words which are mapped using the input file.
I thought we could probably have a combo box dropdown for each highlighted keyword so that it can display the checklisted words.
Then the user again presses the unique key again to shift to the next highlighted word.
Once the user is done viewing all the keywords we have a reset command button which removes the formatting on all the highlighted words and makes it as plain text.
Country --àCountry on the click of the command button.
[FONT='Calibri','sans-serif']Keyword_ID[/FONT]
[FONT='Calibri','sans-serif']Keyword[/FONT]
[FONT='Calibri','sans-serif']Fruit[/FONT][FONT='Calibri','sans-serif']1[/FONT]
[FONT='Calibri','sans-serif']Country[/FONT][FONT='Calibri','sans-serif']2[/FONT]
[FONT='Calibri','sans-serif']Sport[/FONT][FONT='Calibri','sans-serif']3[/FONT]
[FONT='Calibri','sans-serif']Animal[/FONT][FONT='Calibri','sans-serif']4[/FONT]
Sheet 1 of the excel file containing keywords
[FONT='Calibri','sans-serif']Keyword_ID[/FONT]
[FONT='Calibri','sans-serif']Checklist[/FONT]
[FONT='Calibri','sans-serif']Apple[/FONT][FONT='Calibri','sans-serif']1[/FONT]
[FONT='Calibri','sans-serif']Orange[/FONT][FONT='Calibri','sans-serif']1[/FONT]
[FONT='Calibri','sans-serif']Grapes[/FONT][FONT='Calibri','sans-serif']1[/FONT]
[FONT='Calibri','sans-serif']Banana[/FONT][FONT='Calibri','sans-serif']1[/FONT]
[FONT='Calibri','sans-serif']Hungary[/FONT][FONT='Calibri','sans-serif']2[/FONT]
[FONT='Calibri','sans-serif']Germany[/FONT][FONT='Calibri','sans-serif']2[/FONT]
[FONT='Calibri','sans-serif']Football[/FONT][FONT='Calibri','sans-serif']3[/FONT]
[FONT='Calibri','sans-serif']Tennis[/FONT][FONT='Calibri','sans-serif']3[/FONT]
[FONT='Calibri','sans-serif']Basketball[/FONT][FONT='Calibri','sans-serif']3[/FONT]
[FONT='Calibri','sans-serif']Lion[/FONT][FONT='Calibri','sans-serif']4[/FONT]
[FONT='Calibri','sans-serif']Tiger[/FONT][FONT='Calibri','sans-serif']4[/FONT]
[FONT='Calibri','sans-serif']Rhino[/FONT][FONT='Calibri','sans-serif']4[/FONT]
[FONT='Calibri','sans-serif']Deer[/FONT][FONT='Calibri','sans-serif']4[/FONT]
[FONT='Calibri','sans-serif']Kangaroo[/FONT][FONT='Calibri','sans-serif']4[/FONT]
[FONT='Calibri','sans-serif']Zebra[/FONT][FONT='Calibri','sans-serif']4[/FONT]
Sheet 2 of the excel file containing the checklist words for each keyword
Reply With Quote