Saving a file

[Guest]

Hello....
I have an "master" Excel spreadsheet with a cell to put in a PO number in
it. After putting in the PO number it is saved to the folder using "save as".
The file name it is saved as is the PO number in the cell. I would like to
have the next number available put in the cell automatically. Right now we
have to look at the last number used in the folder before we do a "save as".
This causes problems due to users who are not computer literate enough and it
does waste time having to be carfull how to save it. I would like to have the
next number (or file name) so that we can just do a "save as" without having
to worry about editing the cell with coreect PO number. Also can the file be
saved as the same text that is in a particular cell like Word does if you use
"save as". It names the file using text from the first line as a default.

Thanks

 

[Bill Ridgeway]

One way (and I'm not sure if this answers your query) is to have -
Next number ---- =max(a1:a100)+1
where the range of cells you want to check.

Regards.

Bill Ridgeway
Computer Solutions