print same sheet with different sequential #

Microsoft Excel 2003 (full)
August 14, 2009 at 13:52:52
Specs: Windows XP
pls, i need an expert advice. i have created a worksheet that has a list of products. this form has a sequential number. the aim here is to have a button in that worksheet that will allow me to choose how many copies of that form i want to print. BUT if for instance i select to print 10 copies of that worksheet, the sequential number for each copy must increase by 1 for each copy. e.g 1st copy, #001, 2nd copy #002 and so on. how can i do this? is excel the best product to do this?

See More: print same sheet with different sequential #

Report •


#1
August 14, 2009 at 14:19:41
There is no function in printing that would allow printing to give feedback to the sheet or any program I know of.

What may work is script a macro related to the button you place on the sheet. Macro would make copies, increment the count and then print them

Perhaps this will get you started

http://computerwhizzard.50megs.com/...


Report •
Related Solutions


Ask Question