Sizing a report based on a dynamic sized table

[abmyers]

Im guessing this probably needs a macro?

I have a table on Sheet 3 that has a dynamic number of rows.

I have a worksheet on Sheet 2 that displays some data from the table that fits the inquiry. For instance right now the table on Sheet 3 has 123 entries and there are 11 entries that meet the criteria that copy over to Sheet 2, using formulas.

Here is the problem. If the table shrinks, then formulas in Sheet 2 suddenly have #REF! errors, and even if the table grows back, Sheet 2 wont fix. I have to manually go fill down.

Is there a way to have sheet 2 delete cells that extend below the matching number of entries, or fill down if it needs more?

For istance, if the table has 100 rows and only 3 meet the criteria, have everything below row three on sheet 2 deleted. If suddenly the table has 1000 enties and 200 fit criteria have Sheet 2 fill down 200.

Ideally, I'd like to have a disclaimer at the bottom of sheet 2 so I'd like to make its location dynamic as well.

Thanks in advance for any suggestions.