Hello All,

I created an excel (Office 07) spreadsheet to track inventory and I am
having trouble with the scanned date field updating everytime someone
opens the workbook. I need to find a way to have the Now() formula
update one time when there is an identical match between columns AorB
and ScanNum range. This is the current formula I have setup to
calculate the date the item was scanned.

=IF(ISERROR(IF(ISERROR(VLOOKUP(IF(LEFT(A2,2) = "IT",
LEFT(A2,6),LEFT(A2,5)),ScanNum,1,FALSE)),VLOOKUP(I F(LEFT(B2,2) = "IT",
LEFT(B2,6),LEFT(B2,5)),ScanNum,1,FALSE),VLOOKUP(IF (LEFT(A2,2) = "IT",
LEFT(A2,6),LEFT(A2,5)),ScanNum,1,FALSE))), " ", NOW())

Unfortunatley I am not as current in VB as I would like and excel does
not offer an option "on update". If anyone has any suggestions, it
would be greatly appreciate.
Thank you,
Chris




--
Libbyc80