Hi,

I have a worksheet that has a number of header rows that should always be visible and can't be changed (Rows 1-10). This worksheet also has 3 rows at the end of the worksheet that contains summation formulas which should always be visible and can't be changed.

In between these two sections, the body of the worksheet has a number of dynamic rows that can increase or decrease as users add or delete rows.

Column C contains a drop-down list of three options. I want to have buttons that, when clicked, will hide all rows where the value in column C equals to the other two options as well as hide any blank or unused rows up to the bottom Totals line. i.e. If I click the button that says "A", only the lines from Row 11 to the bottom line that contain "A" and "All" will be shown. The Totals line will always be visible.

I've attached a sample of the workbook... hopefully it gives a better idea of what I'm trying to accomplish.

SampleBk.xlsx

Any help would be greatly appreciated!

Thanks