you can use datafilter to hide rows. Suggest a macro to hide the rows and
columns based on your criteria.

for each c in selection
if c=1 then rows("1:5").hidden=true
etc
next

--
Don Guillett
SalesAid Software

"Sqwilly" wrote in message
...
I have created a bid template that calculates a price based on the count
that
I give it
Example: 22 item abc $45
$990
12 item cba $12
$144
if the item count is 0, I would like it to hide that row, and when I print
the bid, I would like to have the option to hide the columns for unit
price
and total price for all items.