Hi people I am currently trying to create an excel file which will create a sequential code that will be linked to an external file.

Within my current file the "sample code" cell is linked with "suite" cell. If "suite" cell is filled, a code is automatically generated into the cell based on how many columns down and so if in "suite" cell B15 the code will be A000-014 this increases sequentially. The spreadsheet contents are then pasted into a new workbook then submited to a lab. However what I want to do is create a code which will look at the last number in this sequence and save it into a txt file so the next time someone inputs data the code will be the next code after the previous. E.g. A000-014 was the last code from monday sample when someone inputs tuesdays samples the first code will be A000-015 increasing incrementally until they finish

Please could somebody assist me with this predicament

Thanks in advance