E
echamp525
I'm creating a sales quote tool for my company and want to hide or
show entire rows based on the value of one cell in a row. I have an
"input sheet" (separate worksheet) that allows the user to specify
whether or not a range of specific products will be included on the
sale quote. On worksheet "Customer Quote" the quantities and sales
price automatically populate through the use of an IF statement. I'd
like excel to auto hide any row in "Customer Quote" when the value is
<=0 and show any row where the value of that specific cell is >=1. I'd
like this code to run each time the values are recalculated as opposed
to having to manually fire the macro each time.
Can someone help me out?
Thanks
show entire rows based on the value of one cell in a row. I have an
"input sheet" (separate worksheet) that allows the user to specify
whether or not a range of specific products will be included on the
sale quote. On worksheet "Customer Quote" the quantities and sales
price automatically populate through the use of an IF statement. I'd
like excel to auto hide any row in "Customer Quote" when the value is
<=0 and show any row where the value of that specific cell is >=1. I'd
like this code to run each time the values are recalculated as opposed
to having to manually fire the macro each time.
Can someone help me out?
Thanks