how do I make an excel workbook into a reusable form

A

ADVRecycle

I used a purchase order template to create a purchase ticket for my business,
and I would like to save it as a "form" that I could use repeatedly and then
print and save each ticket and start a numerically consecutive blank for my
next purchase.

To be more specific, I buy scrap metal and would like a form to purchase
from clients as it's received, print and save then have a blank form to input
the next purchase with an ascending ticket number.

I created drop down lists and formulas for the catagories and pertinant info
but I currently have to manually clear everything after every ticket to reuse
it for the next purchase.

Thanks in advance
 

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

Copy previous record into form field 0
how do i split a cell into 2 under a heading 2
How do I clear a form? 0
Report base on a query from a form? 8
How do I lookup the number of unique values from a list? 0
how do I create an Excel formula or that moves to the next row on 0
How do I automate the numbering of a purchase order form. 2
How do I set up a counter to keep track of prited copies (2 pages. 1

Top