Dear Sir/Madam
I hope you can help me. I’ve got an idea for helping my boss make our work much easier. We are doing all work by hand with pen and paper.
I’ve thought up a workbook with four sheets named “Employees Summary”, “EMP001”, “EMP002”, “EMP003” and a number of customer account sheets. Customer account sheets are named by their account numbers.
Now for the hard part.
I will have three employees. All of us will have to login to the workbook with a username and password. Usernames would be. Administrator, EMP001, EMP002, EMP003. You should be able to change your password at any time.
All sheets will be visible to the administrator. Employees will only be able to see their respective “EMP” sheet and "Employee Summary" sheet. the rest is hidden.
And the really hard part
Every employee will enter all their transactions for the day into their respective sheets.
When a customer comes in to pay or purchase the employee enters it into his/her sheet and press the “Process Transaction” button. A Msgbox will appear (”Are you sure you want to process this transaction?”). If No then cancel transaction, if Yes process transaction. This transaction will then be added to the relevant customer’s account sheet together with the employee reference for that transaction.
The transaction will also be added to the list on that employee’s sheet. And to the list on “Employees Summary” sheet.
This is a tall order and a real mouth full. I really hope that this is possible and that someone can help me with this.
All help will be severely appreciated.
Thank you in advance.
Bookmarks