View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grantcomm grantcomm is offline
external usenet poster
 
Posts: 1
Default 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