Excel 2002 Auto Number

N

nevesone

I two spreadsheets 1. invoice 2. quote. There is a cell for the inv. # and
quote #, is there a way to have these cells generate a unique # (based on
adding one to the last time it was printed or used?). I was thinking abouting
creating a spreadsheet for the cell to reference the sequence from, but i'm
still not sure how to bring it all together. Anyone have any thoughts,
solutions? I appreciate it.
 
Top