asked on

Choosing only data that is available - Excel

Hello

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.

Best Regards
wdelaney

Patrick Matthews

Hi wdelaney05,

I would recommend you rethink the way this works. From your description, it shounds like each product
occupies a different column. From a data modeling perspective, this is a bad choice.

In my opinion, you will be far better off in the long run by using a database app instead. Access actually
comes delivered with a simple order entry template that I suspect will handle your needs with just a little
tweaking.

Regards,

Patrick

ASKER CERTIFIED SOLUTION

GrahamSkan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

W D

ASKER

Thanks you two for the answers. I agree with you on the Access database. That is something I need to do some more research on to utilize.

Best Regards,
wdelaney05