Hey people,
I have two sheets in the attached workbook, Sheet A and Sheet B. Both sheets get job numbers assigned to them manually by the scheduler.
This is what I'm looking to have happen:
When any worker in Station 1 through 10 is done their part of the job number, they open the workbook, find the number in their station row on Sheet A, and double-click it to have it strikethrough. Excel then checks the cells to the right of the one that was just stroked through for any more instances of the same number, and if it finds any, nothing further happens.
If there are no more occurrences of the same number in that station (some stations have more than one row), then Excel finds that number that was just stoked through on Column B on Sheet B; then marks an X and colours the cell red to the right of that number, in the column that corresponds with the station from Sheet A.
Yikes, I hope that was clear. The attached workbook should help clarify. How can I do this?
Bookmarks