Item Price Buyer
Piano $3,000.00 Felix Mendelssohn This sheet is a list of auction
Violin $1,000.00 Franz Schubert items, and their prices. As
people purchase each item, the
Viola $900.00
user enters the buyer's name in
Cello $2,500.00 Wolfgang Mozart the "Buyer" column.
Flute $950.00 Felix Mendelssohn
Oboe $750.00 Wolfgang Mozart
Trumpet $800.00
Trombone $1,200.00 Felix Mendelssohn
Pipe Organ $6,000.00 Wolfgang Mozart
Tuba $2,400.00
Clarinet $950.00 Felix Mendelssohn
Harp $2,500.00 Wolfgang Mozart
of auction
rices. As
each item, the
uyer's name in
Invoice
Wolfgang Mozart
Item Price This sheet, and the two that follow, should automatically list ea
that the buyer purchased, according to the first sheet. (As the
entered, or with a button to click - "Generate Invoices"). The t
is that each item needs to be entered on a new line. Normally
just do this manually - sort the list in the first sheet by buyer, th
and paste their set of items into their invoice. The problem is
are 150 items, and about 50 different buyers. Each person m
one or many different items. I don't want 150 lines on each in
they need to be set up automatically, without the use of VBA.
realize that Access would be a much better choice of software
this - I need to know how to do this in Excel for my training. :)
Subtotal $0.00
Taxes @ 14% $0.00
TOTAL $0.00
should automatically list each item
g to the first sheet. (As they are
Generate Invoices"). The tricky part
ed on a new line. Normally I would
the first sheet by buyer, then copy
r invoice. The problem is that there
nt buyers. Each person might buy
want 150 lines on each invoice. But
y, without the use of VBA. And yes, I
h better choice of software to use for
in Excel for my training. :)
Invoice
Franz Schubert
Item Price
Subtotal $0.00
Taxes @ 14% $0.00
TOTAL $0.00
Invoice
Felix Mendelssohn
Item Price
Subtotal $0.00
Taxes @ 14% $0.00
TOTAL $0.00