How to generate a form from an entry?

J

John Smith

I hope I explain this correctly.

I have a spreadsheet that merely is to record an entry instead of writing it
in a paper form.
For example:

Entry #, customer, color#, Charge, Date.

This is just to record the submission of a color chip to a vendor.

THEN, we have to get an actual pre-pinted form and fill out all the same
information, as well as some other info and fax it to our color vendor. The
spreadsheet is just for us internally.

What would be fantastic is, if after entering that line in Excel, somehow we
would then be able to print the form that we have to fax, with all of the
data from the entry and a few check boxes and such, filled out manually if
necessary so it can be faxed to vendor.

As I'm writing this, I'm realizing that it could work in reverse as well,
meaning that a form could appear in excel and after filling out the form and
printing it, the entry could be filled out automatically.

I know if you saw it, you'd understand what I mean, so I hope someone gets
what I'm trying to accomplish.

ANY direcection whould be wonderful
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top