LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default printing blank forms with auto generated numbers

This seems like a simple macro function but I cannot figure out how to make
it work. I am trying to print inventory forms so I will need a lot of them
and to make sure we don't lose any I want them individually numbered. I used
a macro to auto generate a number for each form, 2 per page when they are
printed. My dilema now is that I need to be able to print, say 500 of them
at a time without hitting print 500 times.

My thought was a field to enter the qty needed that would drive the macro to
repeat itself x number of times......anyone have a function for this?
Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrosponding excel generated numbers with 1st row numbers Anne_Nev Excel Worksheet Functions 1 May 31st 07 04:25 AM
Hiding the results of a formula generated from a blank cell Will Emms[_2_] Excel Discussion (Misc queries) 4 April 18th 07 05:18 PM
I want random numbers generated without repeating numbers Johncobb Excel Worksheet Functions 2 September 7th 06 04:52 PM
Auto generated dates Fifi Excel Discussion (Misc queries) 1 March 31st 06 04:37 PM
to find missing serial numbers in randomly generated numbers B.H. Hadi Excel Worksheet Functions 2 December 1st 05 10:56 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"