Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make an excel workbook into a reusable form
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make form summary report in excel? | Excel Discussion (Misc queries) | |||
Can you make a tab entry form in excel like you can in word | Excel Worksheet Functions | |||
How do I make a checkbox bigger in an excel form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
How do I create a reusable template | Excel Worksheet Functions |