I have a template I use to enter information about customers, every time I
save the file with a distinctive name.
Here is what I want, in the Save As dialogue box should automatically be
filled in a serial number based on the previous workbook, so I can track
sequential numbers.
Is there anyway excel lets me do this?