Our finance director has it in her head that there's some way in Excel that you can put data in a cell, then once it's in, when you save the file the cell generates the next number in the sequence.
To make it clearer, we want to use Purchase Orders in Excel. We obviously have PO numbers which are in sequence, so she wants to make the spreadsheet open to everyone, with a PO number in a certain cell. Once someone enters the details for a PO, then save the document, the next PO number is automatically generated in the same box as the previous, with nobody being able to edit the previous PO. She uses the term "sealed cells" for it but she's not sure if it's correct.
Does that make sense? Does anybody know anything about it? Even knowing the name of the function would be a start as I don't know what to search for to find tutorials.
Thanks for any help!


LinkBack URL
About LinkBacks
Reply With Quote


