I think in this situation you'd probably be better off using some sort of
specialized software to do a library function. I'm sure there's plenty out
there that will do what you're looking for with far less pain and suffering
on your part.

"line" wrote:

What I want to do is to have a cell 'remember' a barcode that has been used
to indicate that a book has been taken out and then returned. For e.g.,

Barcode Date-Out Requested by Date-In

801010101 07/08/08 J_doe@cc[1]. xxxxxx

The 1st time the barcode is scanned for the item the date will auto populate cell 2. When it is returned, I want to be able to scan the barcode and have the 'memory' of that 1st scan auto populate the Date-in cell (cell 4) all in the same record.

Do you have any ideas to lead me to a solution?