Search keyword in a column & if any keyword match then cut that full row & paste it

[computron]

Search keyword in a column & if any keyword match then cut that full row & paste it into another sheet.

Hi,

please help me out for a macro solution for below routine process.

In one excel workbook, 10 worksheet is available name is given like (HP, ACER, Toshiba....) and in first worksheet name is (all_data) includes all models of HP ACER & Toshiba, i want to assign few keywords related to hp laptops, that keywords will be found in all_data worksheet, macro should automatically match any keyword related to hp & move that row to HP worksheet, same i would like to assign few keywords for acer & toshiba laptops, macro should automatically match keywords assign to acer & toshiba & move that row to acer & toshiba worksheet.

Please help me out with the macro,

thank you in advance.

[Palmetto]

Cross posted at Ozgrid:

http://www.ozgrid.com/forum/showthread.php?t=149267