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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
how do i split a cell into 2 under a heading 2
Report base on a query from a form? 8
Blank Report as Attachment 1
How do I insert the value of a cell into a Hyperlink 1
Order form design 3
How do I automate the numbering of a purchase order form. 2
How do I create a purchase order log in Excel? 1

Top