+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    12-27-2010
    Location
    UAE
    MS-Off Ver
    Excel 2003 or Excel 2007
    Posts
    1

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

    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.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

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

    Cross posted at Ozgrid:

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

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1