Results 1 to 22 of 22

List Extracted Rows Of Specified Data From Another Workbook

Threaded View

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question List Extracted Rows Of Specified Data From Another Workbook

    Hello,

    I have two workbooks. One is called the Extraction Sample, which is attached, and the second is the Sorted Results workbook.

    The Extraction Sample workbook contains a master sheet with data in a chart, which gets updated periodically. The Sorted Results workbook contains a list of specific extracted results from the Extraction Sample workbook.

    The formula I am trying to create for the Sorted Results workbook needs to do two things:

    1. Extract only the rows from the master sheet in the Extraction Sample workbook which contain the word 'Thing' in column D.
    2. List the extracted rows on the Sorted Results workbook in numerical order using the data from Column B.

    What would be the best way for me to accomplish this? Thanks in advance for your wisdom.
    Attached Files Attached Files
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Specific rows in several worbooks need to be extracted to a new workbook
    By patchpollito in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2013, 04:21 PM
  2. [SOLVED] Using VBA how do you close a user defind workbook after you have extracted data
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2012, 06:00 PM
  3. [SOLVED] Extracted names from list if value greater than 2
    By MajorT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2012, 10:05 PM
  4. Cannot view personal workbook on doc extracted from database
    By fabrecass in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2011, 09:43 AM
  5. New sheet name extracted from various cells, sorting sheets, saving new workbook
    By Luccin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2010, 05:51 AM

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