Excel template and access questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are going to use the Excel purhase order templates. We need to save each
order in order to refer back to it. Is there a way to do this without saving
each individual file (order)? Can we save in some sort of easy to locate
"batch"?
Also, is there a way to transfer a template that we have done (and all the
data realted to it) into a Acess database withouthaveing to so much tweaking?
 
If you have Access, I would suggest creating your purchase order database in
Access and then having a mail merge push this information into an Excel
template as needed, rather than going the other way around. This will solve
both of your problems.
 
You must log in or register to reply here.

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

Similar Threads

Excel template location 1
creating order book in excel 2007 2
How to save formulas when creating templates 4
Excel Templates 2
Startup Template - Excel 2007/Vista 7
Can Excel sequentially number each new document? 1
Defining Sort Order in Excel Template 1
How do I save Pivot Table Data 4

Back
Top