+ Reply to Thread
Results 1 to 2 of 2

vba to extract rows with specific words on another sheet

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    vba to extract rows with specific words on another sheet

    I need to check specific items starting with SADC on a sheet "SUMMARY ALPHS" COLUMNS A, however the list is exhaustive of 1200 rows MINIMUMN.

    Looking a macro to extract all the ITEMS from columns A with SADC only and its corresponding data to corresponding sheet
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: vba to extract rows with specific words on another sheet

    You can use Advanced Filter.

    I've set up Criteria in a separate sheet, but it can be on the same sheet.

    Please Login or Register  to view this content.
    Click on the button to bring over the data.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract rows to another sheet based on specific words + auto updates
    By scooter2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2022, 09:17 PM
  2. [SOLVED] Extract specific words/strings from a cell
    By deerguy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2017, 05:17 PM
  3. [SOLVED] looking formula for Extract Specific WORDs in existing LONG Words
    By santosh226001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2013, 08:21 AM
  4. VBA macro to extract specific rows and paste them onto a new sheet
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 10:28 AM
  5. How can i extract specific words from a cell?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 06-17-2013, 12:27 PM
  6. Replies: 1
    Last Post: 07-13-2012, 08:17 AM
  7. Extract specific words from cells
    By Santa-D in forum Excel General
    Replies: 6
    Last Post: 06-18-2006, 11:10 PM

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