I'm trying to work out the best approach to creating a stand alone excel spreadsheet that can act as a
mini stand alone invoice database.
Nothing complicated, this is what it needs to do.
1 - When opening
spreadsheet, user is presented with a nice custom "create invoice" data entry form. Fill in the blank boxes (name,
price, date, etc..) and click a Save button.
2 - Save takes the user input fields and adds them to a new row in a different sheet. Each time you click save, a new row is
added, and the "create invoice" form gets cleared ready for a new one.
3 - Open existing. Clicking a button next to an existing invoice will load the data in that row back into the first
"create invoice" form. User can modify this information, and update the invoice.
I guess this is
similar to what excel provides with the Data>Form tool, it just needs to look nice :D
Any guidance on where I
should begin would be appreciated, or if anyone has seem something similar that I could hack to get working that would be