Results 1 to 6 of 6

vlookup - extract all row data from "master" for the clients listed in "NewSheet"

Threaded View

  1. 09-18-2008, 02:22 PM #1
    no dice
    no dice is offline
    Forum Contributor
    Join Date
    07-10-2007
    Location
    Portland, OR USA
    Posts
    135

    vlookup - extract all row data from "master" for the clients listed in "NewSheet"

    Hi All,

    I think I have a vlookup question...

    In a "master" spreadsheet I have a few thousand rows of data in coulmns A thru R.

    In a "NewSheet" spreadsheet I'd like to grab all data from the master spreadsheet where the data in column J (company name) matches any company name from NewSheet.

    The ultimate goal is to extract all row data from "master" for the clients listed in "NewSheet"

    Examples attached.

    Can anyone help me? Thanks!
    Attached Files Attached Files
    Last edited by no dice; 09-18-2008 at 02:54 PM. Reason: Edited title to include, "vlookup"
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Extract
    By joeserrone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2008, 11:34 PM
  2. Extract data from specified id
    By shrimp89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2008, 04:31 PM
  3. HELP: Extract x data from 1 sheet to another
    By Databasebot in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-16-2006, 03:12 PM
  4. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 AM
  5. Need to extract random data using set criteria...
    By dance621 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2006, 06:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1