Let’s try to be as simple as possible. I have an order list in cells A1:G10 where all my clients are listed as well as what they want to order for the next day. Close to that order list, I built an invoice form in cells H1:P15 with various VLOOKUP functions getting data from the order list. The invoice form contains, in cell J3, a dropdown list of my clients (the source of that list is A2:A10).
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
I would like to run a macro that would print out invoices taking the two following parameters into account: 1) the macro needs to go through ALL the clients from the dropdown list and 2) print out ONLY invoices for clients that placed an order (not all clients order every day). That second condition is fulfilled if cell P14>0 (in P14 you have the total amount due by a client).
<o></o>
Having no knowledge of macro programming, I don’t know how to handle that problem. Thank you very much for your help and advice on that matter.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I would like to run a macro that would print out invoices taking the two following parameters into account: 1) the macro needs to go through ALL the clients from the dropdown list and 2) print out ONLY invoices for clients that placed an order (not all clients order every day). That second condition is fulfilled if cell P14>0 (in P14 you have the total amount due by a client).
<o
></o>Having no knowledge of macro programming, I don’t know how to handle that problem. Thank you very much for your help and advice on that matter.
