oam
06-11-2014, 07:32 PM
I work in a facility where items we process must be used in order by sequence number. The items are issued out of the storage room by scanning the sequence number(s) and the employee signing the issue log (see below for example log), there by taking possession of the item(s).
I would like to know, is it possible to have a formula or macro to look at the sequence number column to identify entries where items are issued out of sequence and have the cell in question change color there by alerting the manager to a problem? The column (E column) is quite long, as much as 4000 rows in the sequence number column. In addition to the Issue (out to employees), sometimes the employee(s) are unable to complete all the items issued to them and the items are returned to the storage room shown in the log as Rcv. (back to storage room) to be issued to the next shift.
Thank you for any assistance you can provide.
11806
I would like to know, is it possible to have a formula or macro to look at the sequence number column to identify entries where items are issued out of sequence and have the cell in question change color there by alerting the manager to a problem? The column (E column) is quite long, as much as 4000 rows in the sequence number column. In addition to the Issue (out to employees), sometimes the employee(s) are unable to complete all the items issued to them and the items are returned to the storage room shown in the log as Rcv. (back to storage room) to be issued to the next shift.
Thank you for any assistance you can provide.
11806