Estimates Invoices from a sheet

  • Thread starter Thread starter imageres
  • Start date Start date
I

imageres

I have created a work book that I use to do Landscaping estimates. Th
system combines sheets containing client info, material cost info
labour info, sight measurements and pricing info to generate a
estimate. The quote worksheet contains all of the potential component
of a job wheather they are used in a given job or not. What I am no
trying to do is produce a client ready estimate that picks up only th
row information from the quote work sheet, that is active (contain
values). In other words I don't want to preformat a estiamte form tha
contains all potential quote items regardless of their relevance.
Is this possible and if so how do I do it or where can I find out?
Thanks Dou
 
Doug,

Assuming there is at least one column that is empty in the rows you don't want
to show, for example a quantity column, you can try this:

- select the column
- Edit>Goto>Special, click Empty Cells (or is it Blanks?)
- Format>Row>Hide

To unhide, click the gray rectangle above/left of cell A1, then
Format>Row>Unhide.

HTH
Anders Silven
 
Thanks for the thought Anders. I just tried your idea and found that i
there is a formula in a cell even if the result is is equal to zero th
Go To will not find the cell to be blank and there is no function tha
points the GoTo to cells that equal zero. Any other ideas?
Doug:confused
 
imageres,

If there are formulas in the column, Edit>Goto>Special>Blanks does not work, as
you have noticed. At the moment I have no alternative suggestion.

Best regards,
Anders Silven
 
Back
Top