Pull data from master sheet to specific sub-sheets

Hi everyone - Mods this may be in the wrong place, if so please move it!

Anyway, what I have is a list of softball players in 5 different divisions. What I need is a way to populate different sheets in the same workbook with the players separated by division. So sheet 1 is the master list, sheet 2 is the MS div, sheet 3 the 12U div and so on. The master list will update daily, and I'd like the sheets to auto update based on the master. I need to pull the entire row based on the division assigned to the player.

I know, this is probably better done in Access, but I don't have it. Thoughts?

TIA, Ray

So you can just have a pivot table off the MASTERLIST that has a filter on division, it will automatically update as the data updates.

Well, you will have to go to one pivot table and hit REFRESH ALL.


If you want additional help, post a sample workbook and I can show you what I mean.

Here are 2 approaches.

1. using formulas...
Put this in ARRAY formula in A2 of sheet 2 and copy down and across...
=IFERROR(INDEX(Sheet1!A$2:A$486,SMALL(IF(Sheet1!$A$2:$A$486="Gold",ROW(Sheet1!$A$2:$A$486)-1),ROWS($A$1:$A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Note1. Change the "Gold" for the specific sheet name
Note2. ARRAY formulas can become a big drain on the system and start slowing down your file

2. Using a PIVOT TABLE
- on the new sheet, select Insert Pivot Table
- Click Table Range and highlight the range on sheet1
- make sure existing WS is checked and that the location is A1
- Click OK
- put Division under Filters
- put Acct 1st name under Rows
Done
Note that PT's need to be updated when you add/change data (and you said you wanted it auto)

Glad it worked for you, thanks for the feedback