Afternoon all,
We have an excel document that lists all of the services available and customers use drop down boxes to select what they require. We have a separate Word document that describes what each service entails. Is it possible, presumably using VBA, to create a custom abridged Word document that only shows descriptions for the services that the customer wishes to buy? Basically if the service isn't required I would like the relevant line/paragraph removed from the Word doc. There's a natural link in that the Excel doc contains the same service references as the Word doc. I should be fairly flexible on the structure of the Word doc if it aids the solution (and looks ok)? I was potentially thinking of using a custom list to itemise the services?
Also, could the Word doc be embedded as part of the Excel doc or would they need to be stored separately? I think an embedded solution would better suit our need but I'm happy to hear what options we have available.
If it helps, I've attached two sample workbooks. I hope that explains my situation clearly enough but if you have any questions just give me a shout.
Cheers,
Snook
Bookmarks