Formula/ Macro to combine data from multiple rows

[kaplan.donna]

I've got a list from a heating company who services customer's and
keeps their list by item (ie: air conditioner, heater, etc) so the
customer id's are the same for each customer, but there are multiple
rows for each customer. In order to do a mail merge and have all of
the customer data be the same (to do billing), everything needs to be
on the same line. The consistant data is their name, address,
customer id. Variable data is the amount owed, item serviced, make
and model number. How do I go about doing this?

 

[dan dungan]

Do you need to send a bill for each item on the list, or have some of
the items already been billed?

 

[kaplan.donna]

Do you need to send a bill for each item on the list, or have some of
the items already been billed?

Ideally, we'd be sending a bill for every item on the list but I want
to put multiple bills on one invoice.

 

[dan dungan]

Try looking at the information at Peter's web site:

http://www.excel-examples.com/article-database.htm

Especially the sumproduct and index links.

I'm leaving the office now. I'll check in tomorrow.

 

[kaplan.donna]

Try looking at the information at Peter's web site:

http://www.excel-examples.com/article-database.htm

Especially the sumproduct and index links.

I'm leaving the office now. I'll check in tomorrow.

It's good info - but we're still having trouble getting it to work. I
think we need some sort of formula (if customer number is the same,
then put it all together on the same line) or macro. Thoughts?

 

[dan dungan]

Hi,

I've been out of the office since last thursday.

Would you mind including some sample data so I could see the format
your using?

Dan