excel as database with form

[bermudamohawk]

I've just found that this company doesn't have an MSAccess licence, so I have to create a Purchase Order / Invoice system by hiding a worksheet in the workbook. My concept is that the workbook would contain 3 sheets:
1, Form
2. Form Template (hidden)
3. data (hidden)

So -
1. on open, copy the form template, find the next sequential number from the "data" sheet
2. user fills out the form, hits a submit button.
3. key fields are copied back to the "data" sheet, populating the appropriate sequence row.
4. worksheet is saved as the sequence number.

I'm overwhelmed, and feel like a wuss.
This sounds like it's been done many times, but I can't find the right start point.

any assistance appreciated

[lancer102rus]

How well you know VBA?
It`s look like you need not assistance, and a full program.
do not torment yourself. order the program for the professionals.

[bermudamohawk]

well enough to understand that this is do-able in excel. I've always been able to assemble code snippets and tweak them to provide the proper results.

[lancer102rus]

Well then use the search upon forum and you will find all code snippets you need.

[Kyle123]

An easy way would be to use the "Data Form" built into Excel, this wouldn't require any code

[bermudamohawk]

Well.
I think that's a great start.
A few minor adjustments here and there, and it will work like a charm.

Thanks for all the help! You guys are great. Very helpful.