I need an excel guru to design a macro, for a voucher system for a health spa.
The system will need to automatically increase each voucher number.
We need to able to add number vouchers and maybe a name and dollar amount, to each voucher in the system.
We would like the system to ask for a name both first and last name, phone number (both are compulsory fields) and email address (this is not a compulsory field)
When the voucher is cashed we would like the system to request the voucher number, and then cross the voucher off the system, but not delete the cell.
If the voucher has been presented then a notice will appear "voucher has been used"
We are able to run simple reports from the spread sheet with a click of a button on the spread sheet