Saving a file
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 |
Saving a file
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 "married with 2 mutts" wrote in message ... 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 |
All times are GMT +1. The time now is 10:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com