It can be done with Excel however it will be more difficult (IMHO) than doing it with Access.
What you're talking about is having a "table" of predefined information that fills in a form based on "events" such as buttons, entering other fields, and some fields based on data from other fields.
I would recommend you use Microsoft Access and learn some VBA - or find someone local that can do some fairly simple VBA (Visual Basic for Applications) for you.
Another advantage of using Access, instead of a spreadsheet such as Excel, is that it is a database. The info will be in there and you can then run reports based on whatever queries you come up with, whereas Excel is pretty much formatted the way you put it in, beyond simple sorting and filters.
Hope this helps.
What you're talking about is having a "table" of predefined information that fills in a form based on "events" such as buttons, entering other fields, and some fields based on data from other fields.
I would recommend you use Microsoft Access and learn some VBA - or find someone local that can do some fairly simple VBA (Visual Basic for Applications) for you.
Another advantage of using Access, instead of a spreadsheet such as Excel, is that it is a database. The info will be in there and you can then run reports based on whatever queries you come up with, whereas Excel is pretty much formatted the way you put it in, beyond simple sorting and filters.
Hope this helps.
