data base

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

I need some help..... If you have one or several invoices, and you
want to keep track of detail, like cust. name, amount, taxes. etc.
creating a Data Base... How you can create it and how I can access,
means, writing everytime an invoice is enter in excel.
Thanks for you help
 
-----Original Message-----
I need some help..... If you have one or several invoices, and you
want to keep track of detail, like cust. name, amount, taxes. etc.
creating a Data Base... How you can create it and how I can access,
means, writing everytime an invoice is enter in excel.
Thanks for you help


.
Click to expand...

Probably best (but requires VBA skills):
Create a Userform that has the necessary input fields for
your invoices. When user clicks button ("Save Invoice")
run code that transfers the data to a list on your
worksheet. Even better if your code does some data
consistency checking, too.

Instead of a userform you could also use one worksheet as
an input sheet, using the Control Toolbox to create macro
buttons to do the transfer of the data.

Without VBA skills, you could set up your list on a
worksheet and use the built-in form feature ("Data" menu,
select "Form..."). Not as user-friendly or customizable,
though.
 
Back
Top