+ Reply to Thread
Results 1 to 2 of 2

Query excel spreadsheet to populate another spreadsheet or worksheet.

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Query excel spreadsheet to populate another spreadsheet or worksheet.

    I was hoping that I could get some help or somebody could point me in the right direction to accomplish the following:

    I need to query/search the B,C & D columns for

    B = "2B"
    C = "3A"
    D = '4B"

    When all these criteria match in the same row

    Copy the row into a new spreadsheet or worksheet in Row 1

    I have to do this multiple times but B,C,D would be different values and I need populate the new worksheet rows sequentially.

    so...

    B = "5B"
    C = "6A"
    D = '7B"

    When all these criteria match in the same row

    Copy the row into a new spreadsheet or worksheet in Row 2


    ect ecthttps://docs.google.com/open?id=0B_k...lYyVzVTWDc4aVE
    Last edited by bsambrano; 08-08-2012 at 02:16 PM. Reason: Link

  2. #2
    Registered User
    Join Date
    08-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Query excel spreadsheet to populate another spreadsheet or worksheet.

    This is what I have so far.... I'm not sure how to incorporate the next string search for:

    B = "5B"
    C = "6A"
    D = '7B"

    Any thoughts?



    Please Login or Register  to view this content.


    ---------- Post added at 08:03 PM ---------- Previous post was at 07:57 PM ----------

    Also B,C & D will have have 50 different values that I need to pull out of the spreadsheet...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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