Dynamic table sizes

This spreadsheet works great just the way it is, but I would like to add the functionality to dynamically size the number of lines in the tables so that I don't have to dramatically edit the spreadsheet every time the user (not me) adds or deletes an employee. I THINK this is an easy problem to fix.

The Printout and Dashboard consolodates information from the Sales Report, based on the Staff worksheet, and ignores staff not on the staff list.

So this is all I need: I need the Printout and Dashboard to automatically (dynamically) have the correct number of lines, based on the Staff worksheet. My goal is that if a staff member is added or deleted on the Staff worksheet, it will automatically be reflected on the Printout and Dashboard. The order is irrelevent. Notice that the Printout and Dashboard only show data from the Sales Report that matches the employee list on the Staff worksheet. This is intentional and correct... not all employees on the Sales Report will be shown.

One important rule that must be followed: this will be viewed on Excel 2008 for Mac, which cannot use VBA or macros.

Any help would be greatly appreciated. And feel free to ask questions if you are not clear how it works.

Hi urngoodhands

If you define name in your Staff sheet and use the formula below. You can adjust the ranges if you require more rows.

Formula:

Please Login or Register  to view this content.