Dynamic Sub-tables from Master - COUNTIF, IF, INDEX, SMALL, ROW, ROWS

**SamB-R** · 10-02-2017, 11:56 AM

NOTE BACK: Question also asked here - https://www.excelguru.ca/forums/show...4775#post34775

I am very much struggling with creating Dynamic Sub-tables from a Master.

I basically want the column (Practice) to auto-populate sub-tables on different worksheets for each practice (here it is Board & HR, Manufacturing, etc.).

The master looks like this:

COMMERCIAL%20TEAM.jpg

The sub-tables have the format:

COMMERCIAL%20TEAM2.jpg
The formula I am using is:

Formula:

Please Login or Register  to view this content.

I have been using this youtube video as a framework:

https://youtu.be/tqCEY5YMyqw

Any help would be much appreciated as I'm now completely stuck! The formula will not pick out the correct 'Practice' nor will it continue with drill through method on other worksheets!

**JohnTopley** · 10-02-2017, 12:10 PM

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**SamB-R** · 10-02-2017, 01:57 PM

AliGW,

I'm really sorry for this. I hadn't given it thought as I was looking for as quick a solution as possible.

Please delete this thread, and I will do likewise elsewhere, and I will repost later.

Best wishes, Sam.