Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Mail merge invoice from excel database
I have an excel database that lists items sold at an auction with the winning
bidder's name and item cost. Each item is listed on a different row. The issue I am having is that the same person has won more than one item. Rather than creating a separate invoice for each item is there a macro or formula I can use so that the information connected to the same name are consolidated in one invoice? There are over 100 items. Data Example: Jim Smith/ table/ $10.00 Jim Smith/chair/ $5 Karen Smith/chair/$25 Basically I want Jim Smith's items to show up on one invoice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
How do I set up Mail Merge using an Excel template (an invoice) ? | Excel Discussion (Misc queries) | |||
how to automate invoice using excel database | Excel Discussion (Misc queries) | |||
Excel merge or data form (for invoice)..help!! | Excel Worksheet Functions |