Hello All,
I have a set of sheets where I put in various types of call centre data - one line item per call. The sheet where this line is entered depends on the type of call.
I would like to have a unique number assigned to the line item when that line is filled (regardless of the sheet on which I happen to be). I think that the easiest thing would be to have a sheet containing the base number from which that unique item number is calculated. For example, I begin answering a call. I enter the date on the next empty line in the sheet according to the call type. Tabbing over to the next cell (column C) will pull the reference number from the base number sheet and put it in the first cell of the line I'm entering. The base number is incremented and overwritten on the base number sheet. I continue to fill in the line. For the next call, I may go to the next empty line on that sheet or it may be another sheet. However, entering a date in column B would still cause the reference number to be automatically entered into that line's column A with the number on the reference number sheet to be auto-incremented.
So, if anyone understands what I'm trying to say, how could I go about doing this?
Cheers,
Notwen
Bookmarks