help

[Dave]

How to use a macro to recalcutate a invoice number, for instant 0001 to 0002
automatical

For a college course

Dave

 

[Don Guillett]

We don't normally do homework here but you were honest about it so here is
some help.
http://tinyurl.com/6l5wy

BTW. Please try to use meaningful subject lines in your posts.

 

[Gord Dibben]

Dave

Check out J.E. McGimpsey's site.

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

Gord Dibben Excel MVP