Generating Invoices from an Order Sheet

[TabathaCashin]

I have a problem that I'm hoping someone here can help me solve. I'
like to generate separate invoices for each customer based on the orde
adn pricing sheets. However, I'd like each invoice to list ONLY thos
products which have been ordered. A sample file is attached.

Is this possible? If so, how?

Thanks so much in advance for your help

+----------------------------------------------------------------
| Attachment filename: example.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=367646
+----------------------------------------------------------------

 

[TabathaCashin]

Doesn't anyone have any ideas????? Or is it impossible. I'd reall
like a reply!!!!

 

[Dave Peterson]

I don't think most readers of your message go through exceltip.com. And that
means they don't get to see your attachment.

And many (most?) people won't open attachments anyway. Too many threats of
malicious code.

You may want to post back with a text explanation of your question.

 

[TabathaCashin]

Thank you for your suggestion.

Sheet 1 is an order sheet which has various products listed in each
column across the top and customers listed in the first column down.
Each product consists of a standing order column, an adjustment column,
a total column and a notes column.

Sheet 2 is a listing of products and their prices (products down first
column, prices down second column).

Sheet 3 will be an invoice generated from Sheets 1 and 2. I need one
invoice for each customer which lists ONLY the products ordered,
ignoring 0 values. THis is where I'm having trouble. I can't figure out
how to tell Excel to ignore 0 values and move to the next total column.
Once that customer is done, I need to know how to tell it to go to the
next customer and repeat the process.

Any suggestions?

Thank you.

 

[TabathaCashin]

Thank you for your suggestion.

Sheet 1 is an order sheet which has various products listed in 4
columns each across the top and customers listed in column 1. Each
product consists of a standing order column, an adjustment column, a
total column and a notes column.

Sheet 2 is a listing of products and their prices (products down column
1, prices down column 2).

Sheet 3 will be an invoice generated from Sheets 1 and 2. I need one
invoice for each customer which lists ONLY the products ordered,
ignoring 0 values. THis is where I'm having trouble. I can't figure out
how to tell Excel to ignore 0 values and move to the next total column.
Once that customer is done, I need to know how to tell it to go to the
next customer and repeat the process.

Any suggestions?

Thank you.

 

[Dave Peterson]

This might be too simple, but maybe you could apply Data|Filter|autofilter to
that range.

Then you can use the dropdown arrows, choose Custom and then choose to show
"Greater than 0".