Account For Manual Slips When Computer Down!

[Patish]

Hi Y’all
When our computerized system crashes we need to use numbered manual slips to process transactions. Once the system is up and running the cashiers must enter the transaction from the manual slip to the computer. They attach the computerized slip to the manual slip. I have an Excel file that I collect the booklets of numbered manual slips still blank from the workstations after the system is up and running again and account for each manual check used.
On the first spreadsheet I enter the blank slips. You can see in the Lobby column of the 4 booklets used each has a number of slips missing. There are normally 25 slips in a booklet. On the second and third sheets there are lists of the numbers representing the manual slips in use at the stations, not yet used. From the first sheet, in this example, you notice that there are 16 slips that were used in the Lobby. I want to be able to show which slip was used on the Lobby sheet. The best way to do this would be to use “conditional formatting”. That would colour over the number that was used, let say the colour red. Once I enter in the date and computerized slip number the colour over the number will change to green. Whatever remains red have not been handed and I need to look for them.
Tall order, but can anyone help, please.

[cbatrody]

Hi,

It's tough to comprehend the requirement by going through the description provided by you. Can you please be more specific?

[Patish]

Hi CB

Yes, I know, so I hope I'll boil it all down to one question. Of the slips in this example there are 16 that have, in fact, been used: Numbers 3376 to 3383, 3401 to 3403, 3426 and 3451 to3454. Is there any way to list the used slips from the form on Sheet1 on a separate spreadsheet?

Hope that's better? Oops, another question!!

Regards

Patish