Automated Counter Service Sheet

Hi ,

I am not familiar with VBA but I think this most likely can be achieved only by VBA.

I am trying to create a back up system for a counter service in a bank. The bank branch has 6 counters.

Assuming the automated counter machine that operates the counters has malfunctioned.

1) Assuming the current number is 1001. There will one staff manually giving away the numbers for customers since the machine has malfunctioned.

2) All counter staff will then have a shared Excel sheet that would show the current number which will be entered manually.

3) By clicking a button in Excel the Excel sheet will allocate the next number to each counter accordingly.

4)Once each counter has completed the transaction or service for the customer, the counter staff can click on a buttion in Excel and Excel will allocate the next number to the particular counter.

Basically the Excel sheet should be able to operate exactly as the automated machine.

Is this possible ?


Appreciate help.