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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
you can use data>filter 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
 
I'm trying to do a similar thing ...


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

Luke.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert columns to rows 6
Excel EXCEL - using a date dependant formula to hide rows 3
Hide unbolded rows in specific column 2
Messed up references when copying sheets from one workbook to anot 2
Faster code to quickly hide several rows? 7
Maintain the same number in a spreadsheet 2
Automatically hide/unhide rows 2
Hide or chg the font to white? 3

Back
Top