results of filtered range to hide/unhide rows in same wrksheet, outside the filtered range

Hello there, I am hoping someone can guide me in building a VBA code (excel 2010) that will, based on the visible results after a filter has been applied to a range, hide rows below and outside of the filtered range.

I have 3 distinct ranges in an excel worksheet that all share common information in the first column, but information in all other columns is completely different. One of the ranges is filtered so that the user of the spreadsheet can narrow down the information he/she sees. What I would like is for the other 2, non-filtered ranges, to mimic the visible results of the filtered range. The point being to hide/unhide the information that is not related to the filtered results.

I've attached the workbook here and noted in column A which ranges I am referring to. I've filtered the "source" range to see only seven of a possible nine items. The result I am hoping to achieve is that, since rows 34 & 35 are hidden because of the filter choices, that rows 21, 22, 59 & 60 would then be hidden as well and once the filter is removed, they would be unhidden.

Good question - yes, ALWAYS on row 15.

I advertently found a work around but I am still very interested in how to do this via VBA.

Originally Posted by jaslake

Hi LuScannon

Will the User ALWAYS be setting the Filter on Row 28 or might they set it on Row 15 or Row 53?
You currently have 11 Lines in each Filter Range...will this EVER change?