Vb code to hide/unhide rows based on entries on another sheet

Hello to all,

With the help of Dave from another forum, I was able to get code to start what I needed to do; however, I still need additional help and would appreciate any input you would give.

Task:
A part number is entered into Cells - "C" (3), or "L" (12) or "T" (20) on the Product Information Sheet.
1) If a part number is entered in Cell "C" then the corresponding Row on the Pricing Calulation Sheet (Rows 33 thru 112) needs to be unhidden - INCLUDING Row 113 (this is the total for this product type).
2) If a part number is entered in Cell "L" then the corresponding Row on the Pricing Calulation Sheet (Rows 119 thru 198) needs to be unhidden - INCLUDING Rows 117 & 118 (headers for the product type) and Row 199 (total for product type).
3) If a part number is entered in Cell "T" then the corresonding Row on the Pricing Calulation Sheet (Rows 205 thru 284) needs to be unhidden - INCLUDING Rows 203 & 204 (headers for the product type) and Row 285 (total for product type).
4) If any Cell has a part number entered then Row # 289 needs to be unhidden.

The code that I currently has - only works if a Part number is entered into Cell "C".

Please Login or Register  to view this content.

I'm attaching sample sheets for you to review and assist if possible.

Regards,