simple Excel question

[ZAP]

Please pardon my ignorance...I've searched and read Excel's help but
can't seem to find the answer to this question.


I am setting up an invoice spreadsheet in Excel 2003 that automatically
inserts product names and prices from another sheet and totals them up
at the bottom.


My question involves formatting the list of products and the total
below. I have no way of knowing if there will be 5 items or 5000 on any
given invoice. How do I set up the line items to be however many the
user enters, and then how do I put the total on only the last page?


THANKS in advance for your replies!


ZAP

 

[Biff]

Hi!

Judging by the number of replies, your question must not
be so simple!

Actually, I think your question is a little vague. Don't
know what you mean by: "How do I set up the line items to
be however many the user enters".

Try posting again (in this thread) with a more descriptive
question - be very specific! Details!

Biff

 

[JulieD]

Hi

the answer involves using VBA code ... if you'ld like to have a look at a
sample workbook that contains this functionality (amognst other things)
please email me direct (julied_ng at hcts dot net dot au) ...

Cheers
JulieD

 

[Bob Phillips]

If you are inserting new rows for each product to add to the invoice, I
assume you are worried about making sure the sum includes all rows?

One way is to have say a standard layout of a header row, 10 rows to add
products, a blank row, and then put the sum in row 13 (e.g. =SUM(D212)).
If you insert any more product rows, ensure that you put them before the
blank row.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[ZAP]

Thanks to all for your replies.

What I am trying to do is to allow users of this file (who are not very
Excel-saavy) to enter line items on an invoice (3 widgets at $3 each, 6
doohickies at $5 each, etc.) and to have the invoice expand/contract to
the number of line items they enter and format it for printing on
multiple pages with a total, etc. at the end.

I gather from Julie's post and the lack of templates with this
funcionality that this would require some VBA code, and since I won't
be around to support this file if there are problems I'd rather not
mess with that now. I'll just show them how to insert rows (how hard is
that?). It seems as if the ultimate solution is Infopath with an Access
database of products, but that will have to wait as well.