hi.
I need help writing a macro that will hide and unhide rows based on the
value in Cell A1. In the below example, If Cell A1=100, rows 3 and 4 would
be hidden and rows 1,2 and 5 would be unhidden. If cell A1=200 then only row
3 would be shown. Thanks in advance for your help, Tami

Column B
Row 1 100
Row 2 100
Row 3 200
Row 4 300
Row 5 100