Unhide contiguous duplicate rows with cell select

[blist]

I am working with 10,000 uniquely numbered Widgets, made up of 2000 different Widget Types. My spreadsheet contains (among other) columns C:F showing WidgetTypes, WidgetsQty perType, QtyReserved, and ID#. The Widgets columnC is filtered/hidden so only the first instance of each Widget Type is visible. Only that first row of each WidgetType contains Qty data; Hidden rows do not contain Qty data. All countif formulas for Qty and countifs formulas for QtyResvd have been pasted as values. The final file will be refreshed every day, and these last two macros must work in Excel2003. I wouldn't have gotten this far along on this project without the generous folks and awesome info on this site, and I'm really grateful for the resource. Stuck, and still grateful...

How to write a macro to unhide subsequent contiguous rows of the same Type when a columnF ID# cell is selected? And then hide the same rows when any Qty cell within the unhidden range is selected?

Thanks in advance for any assistance and direction...

 

[blist]

Admins,

Please delete this post/thread. I restated a simpler and more focused question in a new thread. Sorry for the trouble...