Create an invoice by marking a schedule of items to be used

[bobkatz33]

I am new to excel. I want to be able to make a invoice on excel. I have up to 10 pages of various food items from appertizers to drinks on 10 differnt pages. I want to be able to place a "number" next to a item and it goes to the invoice page.
I am going to need help on how to do this please.

Thank you

[Richard Buttrey]

Hello, and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


Since you're new here I'll change it for you on this occasion but please note for the future.

[aydeegee]

Hi bobcatz33

It would be much easier if the data were only on one page! The attached sheet does what you ask. Note that the formulas within the braces "{ }" are array formulas and have to be entered using Ctrl+Shift+Enter rather than just Enter.

I have just noted that you probably do not need VAT, but I have left it in case it gives you ideas for other items.

Let me know if you have any queries

Regards
Alastair

[Richard Buttrey]

Hi,

As Alastair has noted you will simplify things immensely if all your items are on a single sheet.

You'll then have a couple of approaches. You could either, as you want to do now, mark all the items that you want to see on an invoice and have a simple data filter macro copy the selected items to the invoice.

Or more normally your invoice would have drop down cells which would allow you to pick the names or codes of items and any associated references or selling prices. These drop down cells would take their selections from your single sheet list.

Just something to think about. And even if you use a formula approach, having a single sheet of items will simplify any formulas considerably.