Emperoralvin
08-12-2014, 11:03 PM
Hi All,
Im new to the VBA scripting world and taught il call upon the pros to help me out.
I need a simple macro which will run against a list of keywords ex:cell-phone-carrying case pull out the line items relating rows with this keyword with the accuracy percentage against the row.
Sheet 1- Data sheet Row 1 will be the data and Column A will be the line to search on.
Sheet 2 - Keywords (ex:cell-phone-carrying-case)
Sheet 3 - Result showing the rows matching the keywords in column A, column B- coresponding keyword and column C accuracy percentage.
Please help as I have a huge dataset that needs to be covered and I have attached the sample sheet for vieiwing.
Cheers
Alvin
Im new to the VBA scripting world and taught il call upon the pros to help me out.
I need a simple macro which will run against a list of keywords ex:cell-phone-carrying case pull out the line items relating rows with this keyword with the accuracy percentage against the row.
Sheet 1- Data sheet Row 1 will be the data and Column A will be the line to search on.
Sheet 2 - Keywords (ex:cell-phone-carrying-case)
Sheet 3 - Result showing the rows matching the keywords in column A, column B- coresponding keyword and column C accuracy percentage.
Please help as I have a huge dataset that needs to be covered and I have attached the sample sheet for vieiwing.
Cheers
Alvin