Hi, I am using the name of the workbook as a serial number too. I would like to use a formula, so that the serial # column reflects the new workbook name, every time I open a new workbook using the "save as" function.

regards, seby