G Guest Jul 28, 2005 #1 Like the date. so every time i open a new one the numbers will increase eg: 1 2 3
P Paul B Jul 28, 2005 #2 Dreamworks, have a look here, http://www.mcgimpsey.com/excel/udfs/sequentialnums.html and if you are new to macros you may also what to have a look here on getting started with macros http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
Dreamworks, have a look here, http://www.mcgimpsey.com/excel/udfs/sequentialnums.html and if you are new to macros you may also what to have a look here on getting started with macros http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003