I have an excel document that i would like to place on a server here at
my workplace that, each time its printed it places a serial number on
the printed sheet starting with the # 6000.

Im pretty clueless with fomulas(ive tried and tried).Any suggestions
let me know.

Regardless, thanks for responses. :)

Yes, it is possible but you will need to employ a little VBA.

See John McGimpsey's site for code.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben MS Excel MVP

On 12 Jul 2006 13:55:21 -0700, "Ryan" wrote:

I have an excel document that i would like to place on a server here at
my workplace that, each time its printed it places a serial number on
the printed sheet starting with the # 6000.

Im pretty clueless with fomulas(ive tried and tried).Any suggestions
let me know.

Regardless, thanks for responses. :)

Thanks Alot!



Gord Dibben wrote:
Yes, it is possible but you will need to employ a little VBA.

See John McGimpsey's site for code.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html