SamB-R
New member
- Joined
- Oct 2, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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:
Master
The sub-tables have the format:
Sub-Tables
The formula I am using is:
=IF(ROWS(A$4:A4)>$E$1,"",INDEX(MASTER!A$2:A$300,SMALL(IF(Table1[Practice]=$B$1,ROW(Table1[Practice])-ROW(MASTER!$C$2)+1),ROWS(A$4:A4))))
I have been using this youtube video as a framework:
<iframe width="560" height="315" src="https://www.youtube.com/embed/tqCEY5YMyqw" frameborder="0" allowfullscreen></iframe>
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!
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:
Master
The sub-tables have the format:
Sub-Tables
The formula I am using is:
=IF(ROWS(A$4:A4)>$E$1,"",INDEX(MASTER!A$2:A$300,SMALL(IF(Table1[Practice]=$B$1,ROW(Table1[Practice])-ROW(MASTER!$C$2)+1),ROWS(A$4:A4))))
I have been using this youtube video as a framework:
<iframe width="560" height="315" src="https://www.youtube.com/embed/tqCEY5YMyqw" frameborder="0" allowfullscreen></iframe>
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!