ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   linking documents, then hiding certain text (https://www.excelbanter.com/excel-discussion-misc-queries/101918-linking-documents-then-hiding-certain-text.html)

grantcomm

linking documents, then hiding certain text
 

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=566098



All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com