Choosing only data that is available - Excel
Posted on 2006-10-29
I am working on a ordering process and trying to automate it. I will give you an example of what I am trying to do below.
When I receive orders for some of my products I place the order in an Excel spreadsheet (address, order #, qty of each product). For each order, it is placed in one row, so if I have an order going to John Smith and he orders 3 out of the 20 products that I have to offer these are all inserted in the same row. From there I run a mail merge in Word to generate a packing list/invoice. What I am looking to do is make it so only the products that are ordered show up on the invoice without specifying a specific place on the Word template for each product.
Is there a Macro that I could use to make this happen?
Please let me know if you need more info.