Automatic "Consecutive numbers" on Excel?

Question

How could I use a forlmula to create consecutive numbers in a .xls File to make Quote.
Example: Quote #: 001 (save it) create a new one, and automatically get my Quote : 002.

All my people on the world.. it is URGENT!
Thank you!!
JAD - J. Adrian D.

Answer 1

You need to write a macro for that

select a cell containing the new workbook name, run macro

sub savefile()
activeworkbook.SaveAs (activecell.value)
end sub