Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to create a PRENUMBERED FORM - two to a page (then just
cut them down the middle to have stock 8-1/2X 5-1/2 forms.) I've begun by creating a simple (single) page/range (A1:G51) on my Sheet1. Within that range I have in Cell C3 "My Form" (which is the Top Copy) Within that range I have in Cell C26 "My Form" (which is the Bottom Copy) Along side each of the above, in column "G", (In say G3 - I want to be able to enter a number, say 1000 Set up a variable Input Box asking How many Form Sheets do you wish to Print? Also, InputBox Starting Number (my 1000 above furnished) and Run the Macro How many Form Sheets? 10 Statring Number? 1000 Solution 10 sheets = 20 forms are produced - numbered from 1000 to 1019 Does such a template exist anywhere? Thanks in advance.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto filling Forms | Excel Worksheet Functions | |||
Filling up Forms | Excel Discussion (Misc queries) | |||
filling web forms from excel | Excel Programming | |||
filling combox box with same logic in 2 < forms | Excel Programming |