This should be a simple project.
I would like to create an Excel project on which a worker can eneter the Date of the transaction / Last name / First Name / Total Sale / Amount Paid in an input box (see example).
This data will enter onto an excel document that sorts the entries by date, then by last name.
Each entry will reveal all of the inputed date and the form will calculate the amount due, per transaction, and the subtotal for the day's sales and payments.
It will alos total all of the subtotals (both) at the end of each month (or as requested, e.g., year)
Snce this idea is evolving, it is imperative that I be provided with the tools and instructions to make changes to the entry screen and data that is being inputted. I may need to add additional fields or change variables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
Microsoft Excel 2003 and 2007 (primarily 2003)
windows vista, xp, xp pro, 7