I have a workbook that is made up of 25 separate worksheets (all hidden). Each worksheet is a scorecard 'rubric' of a particular skill (ie, adaptability, sales skill, technical skill, etc.) A master worksheet then has a 'dropdown' box in which you choose the particular skill. Once chosen, that particular skill worksheet becomes 'visible' in the dropdown worksheet. The worksheets are made up of a table that is 5 columns by a maximum of 12 rows. The 5 columns are static and never change. However, depending which 'skillset' you choose it may have 3 rows up to 12. If you're familiar with what a grading 'rubric' looks like, this will give you an idea. Change the skillset and a new one replaces the previous. My issue is this: The maximum of 12 rows always show up, even if the sheet you select only has 3 active rows. The other rows used to show '0' (my previous question), but we corrected them to just be 'blank'. What I'd like to do is have the page adjust to eliminate (or hide) the blank rows altogether when a sheet with less rows is present. Is this possible? That way when we print it sizes to the sheet and does not have all the blank rows.
Any suggestions?
Any suggestions?
