View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do I make an excel workbook into a reusable form

hi
see this site
http://www.ehow.com/how_13117_create...-template.html

regards
FSt1

"ADVRecycle" wrote:

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