Need to build a Macro that can dynamically add rows to a table based on criteria

Hi,

I'm working on this tool that is going to require copying data into a specific range of cells. However, the size of the range is going to be determined by the results of a filter.

I've posted my workbook in case anyone online is interested in helping.


Here is how I anticipate the information flow:

1. User is going to run the filter on worksheet TPT
2. Worksheet SampleData is where the filtering happens and will copy the result to worksheet FilterReturn
3. FilterReturn data is going to be counted in worksheet BoxTotals
4. The maximum number in BoxTotals is suppose to set the Matrix size on worksheet TPT - The matrix has 9 boxes, and will have a minimum of 10 rows by 2 columns (fits 20 entries, First and Last Name in one cell)
5. Then, the results on FilterReturn should populate into the corresponding boxes in the Matrix

That's the flow that I'm hoping for. It sound logical to me. Just not sure how to dynamically change the Matrix Table on TPT and then copy the FilterReturn data into the boxes.

If anyone has any suggestions or idea, I would love to hear them.


Thank You.