How to hide rows and/or columns using a formula in excel
 

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.

How to hide rows and/or columns using a formula in excel
 

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.

How to hide rows and/or columns using a formula in excel
 

I'm trying to do a similar thing ...


Is it feasible to execute a similar macro from within a if() function?

Luke.

"Don Guillett" wrote in message
...
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.

How to hide rows and/or columns using a formula in excel
 

Formulas can't do that kind of thing.

But there are workarounds. There are worksheet events that can be on the
lookout for a value in a cell. And that can be just as effective.



Luke Vogel wrote:

I'm trying to do a similar thing ...

Is it feasible to execute a similar macro from within a if() function?

Luke.

"Don Guillett" wrote in message
...
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.



--

Dave Peterson

How to hide rows and/or columns using a formula in excel
 

Thanks Dave ...

Me thinks more investigation is needed.

Cheers.

"Dave Peterson" wrote in message
...
Formulas can't do that kind of thing.

But there are workarounds. There are worksheet events that can be on the
lookout for a value in a cell. And that can be just as effective.



Luke Vogel wrote:

I'm trying to do a similar thing ...

Is it feasible to execute a similar macro from within a if() function?

Luke.

"Don Guillett" wrote in message
...
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.



--

Dave Peterson