Invoice System Help

**ROSH22** · 04-05-2012, 06:28 AM

Hey,

I am looking to create a system where by.

The workbook will act as a template for invoice creation and also a database for all created invoices.

It will have a 'save' button. Upon pressing the save button, the information filled out on the invoice form, such as Customer Name, Date, Order Value etc. are moved into a database in a separate sheet inthe same workbook, and also a save prompt comes up, allowing the user to save the invoice they created. Once the invoice file is closed, the template clears itself for the next entry, but the information in the database remains.

Does anyone know how to go about this?

Thanks!

**Spencer101** · 04-05-2012, 06:35 AM

Have a look in Excel help for "Data Form". There is a built in capability that does most of what you're after.

**royUK** · 04-05-2012, 07:27 AM

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.

I've developed similar systems that generate invoices, copy invoices, statements & reports but it is not a short job to do it properly

Invoice System Help

LinkBack

Thread Tools

Rate This Thread

Display

Invoice System Help

Re: Invoice System Help

Re: Invoice System Help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions