Getting Multiple Rows From a Table

**Gobble** · 04-30-2017, 02:51 PM

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!

**protonLeah** · 04-30-2017, 05:01 PM

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!

**Gobble** · 04-30-2017, 05:11 PM

Here is the example.

Thanks guys!

**protonLeah** · 05-06-2017, 11:20 PM

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.

**peterrc** · 05-07-2017, 10:14 AM

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

Getting Multiple Rows From a Table

LinkBack

Thread Tools

Rate This Thread

Display

Getting Multiple Rows From a Table

Re: Getting Multiple Rows From a Table

Re: Getting Multiple Rows From a Table

Re: Getting Multiple Rows From a Table

Re: Getting Multiple Rows From a Table

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table with multiple rows/sub rows

Date Stamp within Excel table - Changes in multiple rows and columns and new rows added

Returning multiple rows from table

[SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table

Return indexes of rows when multiple rows of a table are selected.

Convert rows with multiple unique columns into individual rows for pivot table management

Bookmarks

Bookmarks

Posting Permissions