Marco VBA code to search keyword pop corresponding id and also map the checklist

[Sri1961]

Using known table 1 and known table 2 a new table is created associating every keyword to a checklist word. For every keyword there may be any number of checklist words. A search is run on a known table 3 to locate the keyword listed in table 1 and the BRQ ID corresponding to the keyword searched is popped out in a new table. Both the new tables obtained are merged into another new table which is the final expected output.

Table1 is a "known" table stored in a separate excel file (DATABASE)
KEYWORD_ID KEYWORD
1 Fruits
2 Markets


Table2 is a "known" table stored in a separate excel file (DATABASE)
KEYWORD_ID CHECKLIST
1 Orange
1 Apple
1 Mango
1 Pear
2 DAM
2 RTCD
2 RTC
2 IFM


Using these two tables which are in the database i need to map every keyword with its checklist terms. Here it so happens that for each keyword there are 4 checklist terms but this may not be the case sometimes one keyword may have 3 checklist terms sometimes 7 maybe 10. So please make sure that the code for this should accommodate that concern.

O/P expected from Table 1 and 2 to be stored in a separate excel file
KEYWORD CHECKLIST
Fruits Orange
Apple
Mango
Pear
Markets DAM
RTCD
RTC
IFM


This output should be stored in a separate excel sheet.

Table 3 is a again "known" table stored in a separate excel file (DATABASE)
BRQ_ID BUSINESS REQUIREMENT
MAPP_BRQ001 We should make sure that Fruits are available in a timely manner
MAPP_BRQ002 The analysis of Markets is essential



Here the code should search for the keywords located in the previous mapped table namely "Fruits" and "Market" and pop the BRQ_ID corresponding to it. For simplicity sake here i have assumed just one table there may be 2 or 3 tables in the same excel sheet. So please make sure that the code can look through all the tables and locate all the BRQ_ID's corresponding to all the keywords in the mapped table.

O/P expected from Table 3 to be stored in a separate excel file
BRQ_ID
MAPP_BRQ001
MAPP_BRQ002

The final merged output i require will have to merge the mapped table and the BRQ_ID table and be stored in a separate excel sheet
BRQ_ID KEYWORD CHECKLIST
MAPP_BRQ001 Fruits Orange
Apple
Mango
Pear
MAPP_BRQ002 Markets DAM
RTCD
RTC
IFM


Let me know if anything is unclear. Please solve it its my project !! that i need to complete