I have linked a our quick quote ( an excel document ) to a word document
which we send to our customers. i have linked the part number, qty of
the part and description to the word document. when we change the
quantity in our quick quote, it changes in our word document- which is
exactly what we want. however, there are 80 parts in the quickquote and
varrying on the job, we usually only use about 7 of them in the word
document, but all 80 show up. how can we hide these unused parts, but
have them automatically show up again if we obtain a quantity larger
than zero?
i know how to hide text, but not to have it automatically come back
when it changes to what we want it to change to.


--
grantcomm
------------------------------------------------------------------------
grantcomm's Profile: http://www.excelforum.com/member.php...o&userid=36894
View this thread: http://www.excelforum.com/showthread...hreadid=566127

I prefer to do the whole thing in Excel. I use a quote input sheet, which
allows for plenty rows. I then use a macro to transfer only those rows I
used to a quote output form, and print it. In this way, I can have a quote
consisting of 1 detail line, or 30 detail rows, with the Letterhead, date,
customer name and address etc above the quote detail section, and the normal
quote footer section directly below the detail section.

"grantcomm" wrote:


I have linked a our quick quote ( an excel document ) to a word document
which we send to our customers. i have linked the part number, qty of
the part and description to the word document. when we change the
quantity in our quick quote, it changes in our word document- which is
exactly what we want. however, there are 80 parts in the quickquote and
varrying on the job, we usually only use about 7 of them in the word
document, but all 80 show up. how can we hide these unused parts, but
have them automatically show up again if we obtain a quantity larger
than zero?
i know how to hide text, but not to have it automatically come back
when it changes to what we want it to change to.


--
grantcomm
------------------------------------------------------------------------
grantcomm's Profile: http://www.excelforum.com/member.php...o&userid=36894
View this thread: http://www.excelforum.com/showthread...hreadid=566127