Invoice

[Bhavesh.Patel]

Hi,
Bhaveesh Patel here from India,Corporate sector
I want to know about in a New office document
Invoice Template i want database in excel sheet
When i enter data in invoice and print invoice and
data will automatically gose to database in excel sheet

how do i ?

Bhavesh

 

[Earl Kiosterud]

Bhaveesh,

This will require some macro coding. Excel has few commands that actually
move data around. You may find it easier to put the data into the database
sheet first(using Data - Form, or your own UserForm), and if that form isn't
in the layout you want for printing, make another sheet that is in the
desired print layout, and extract the record you want to print (probably
using VLOOKUPs). This is more of an Access application, probably.