I need an excel workbook with seven different sheets.
1. The first will store details of clients, their addresses, dates of birth, tax number etc. There will be about forty fields.
2. The second sheet will store details of each case. Each client will have more than one case. This may have 100 fields. When the number of the client is entered for a new case, certain fields should be automatically populated with relevant information that is already in the client sheet. There may be one hundred fields with information regarding each case.
3. The next sheet will store records of time spent on each case and the total of time spent for each case will carry back to the cases sheet. This sheet will have about 10 fields.
4. The next sheet will store details of wills held by us for each client.
5. The next will store details of deeds held for us by each client.
I will need macros to have attractive input screens for each sheet.
I will retain copyright of the sheet and be able to amend it as I see fit.
I will need a small sample of the work (with, for example, the first two sheets with four fields in each showing how information flows from one to the other) and a data entry screen before deciding to proceed with the balance of the project. I will pay €[url removed, login to view] for this and will retain copyright if I decide not to proceed.