Recording numbers in a new file
 

I use an Excel form to generate sales quotes. I would like for Excel to
generate a sequential quote number in one cell on the form and then
record that number and data from several other cells (customer name,
project, date, etc) into a master file that would keep track of all the
quotes. Any thoughts?


--
IndyStageRandy
------------------------------------------------------------------------
IndyStageRandy's Profile: http://www.excelforum.com/member.php...o&userid=33616
View this thread: http://www.excelforum.com/showthread...hreadid=533942

Recording numbers in a new file
 

Here is a start:

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

--
Regards,
Tom Ogilvy


"IndyStageRandy"
<IndyStageRandy.26hbfz_1145395801.8692@excelforu m-nospam.com wrote in
message news:IndyStageRandy.26hbfz_1145395801.8692@excelfo rum-nospam.com...

I use an Excel form to generate sales quotes. I would like for Excel to
generate a sequential quote number in one cell on the form and then
record that number and data from several other cells (customer name,
project, date, etc) into a master file that would keep track of all the
quotes. Any thoughts?


--
IndyStageRandy
------------------------------------------------------------------------
IndyStageRandy's Profile:
http://www.excelforum.com/member.php...o&userid=33616
View this thread: http://www.excelforum.com/showthread...hreadid=533942