linking documents
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 |
linking documents
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 |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com