Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Macro to extract specific desciptions

    have decriptions in Col B on sheet1. I would like a macro to do the following

    1) Extract descriptions that contain the following text to sheet2 (including Cols A:B)

    sale, sales, fact assist , discount, DIC & rebates, F & I (for eg sale pine desk, fact assist pine desk, discount retail desk, F & I sales)

    2) Extract descriptions that contain the following text to sheet3 (including Cols A:B)

    COS, O/allowance (for eg COS pine desk, O/allowance,

    Your assistance in this regard is most appreciated

    http://www.mrexcel.com/forum/excel-q...sciptions.html

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    ..do you want the matching data appended to existing records on the destination sheet?
    ..or do you want the destination sheet to only contain the matching records?

    zeddy

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    I want the destination sheet to only contain the matching records

    Howard

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    See the response at http://www.mrexcel.com/forum/excel-q...ml#post3560130

    Steve
    PS Howard, I do not feel that giving responders <15 min to respond on the other board is sufficient time to give them a chance. I think you should wait at least a few days before you give up on your initial posting to try another board. As it was you got an answer there in < 3 hours.
    Last edited by sdckapr; 2013-08-29 at 07:41.

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Steve

    Will adhwre to your comment in future

    Howard

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    That was a cracking piece of code in the response Steve highlighted above!
    Very impressive.

    But note that, if you use it alone, it will append to any existing data on your sheets.
    So, you should clear the data on those sheets first.

    zeddy

  7. #7
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    The code is very impressive. Will amend code to first clear the data on Sheets 2 & 3. Wish I could program. I'm learning all the time from guys like you, Steve, Maudibe, Retired Geek as well as others on this Website & MRexcel who devote a lot of their time by helping others like myself. I have learnt a lot, but want to learn more.

    I',m in the process of purchasing "Excel 2007 VBA" DVD from the MrExcel Website developede by Bill Jelen who founded the MrExcel.com Website.

    Howard

Posting Permissions

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