+ Reply to Thread
Results 1 to 5 of 5

Getting Multiple Rows From a Table

  1. #1
    Registered User
    Join Date
    04-30-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    5

    Getting Multiple Rows From a Table

    Hey Guys,

    I have data I want to insert into a table. The table will have the following Date, Username, Nickname, Amount. There will be duplicate Usernames and Nicknames for
    each person.

    I want to have tabs for each of these people and inside them, I want to pull all rows for the username Mike for example.

    How would I do this?

    EG: I have a tab called Mike. It looks inside the table and finds all the Usernames: MIKE. Then pulls every row of Date, Nickname and Amount for the user Mike and puts it into
    my MIKE Tab.

    Thanks!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Getting Multiple Rows From a Table

    Use the macro recorder: Use Excel's FIND function to find the name, copy and paste it elsewhere. Save the macro and post the workbook so someone can help you witha Find.Next loop.
    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-30-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    5

    Re: Getting Multiple Rows From a Table

    Here is the example.

    Thanks guys!
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Getting Multiple Rows From a Table

    this formula in A3:D3 will extract the records associated with name in A1 to rows on the new sheet:
    Please Login or Register  to view this content.
    The macro will add new sheets and copy data:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by protonLeah; 05-06-2017 at 11:54 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Getting Multiple Rows From a Table

    Or you could do it using a Pivot Table.
    Use "Player" as a Report Filter.
    Use "Show Report Filter Pages" to automatically create a Pivot Table for each Player / Name.
    Please see attached.

    Regards

    peterrc
    Attached Files Attached Files

+ 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. Pivot Table with multiple rows/sub rows
    By j_cole in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-01-2016, 07:05 AM
  2. Date Stamp within Excel table - Changes in multiple rows and columns and new rows added
    By jarheadmctavish in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-09-2016, 03:22 PM
  3. Returning multiple rows from table
    By frune in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2015, 10:11 AM
  4. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  5. Return indexes of rows when multiple rows of a table are selected.
    By samkumar in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 04:54 AM
  6. Replies: 1
    Last Post: 11-29-2012, 06:24 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