OK Guys, what I'd like to do is have an Excel Workbook which, when opened, presents the user with a page with several empty fields with headings such as "Address", "Contact Number", and "Surname", with the only accessible field being "Surname". Once the user types in a surname, all the other fields are populated with the subjects relevant details. Basically a Personnel database.
I'm pretty sure Excel can do this, but I don't know how to implement it - I know I'll need two sheets in the workbook - one for the 'user interface', and one containing all the personal data, I just have no idea of how to link the two; how data will be retrieved and displayed on the interface sheet; and what format to enter data on the personal data sheet.
Can anyone point me in the direction of a good online tutorial, or give me a basic steer to get me started? I've had a look myself online, but nothing fits the bill. Am I asking too much of Excel?
I'm pretty sure Excel can do this, but I don't know how to implement it - I know I'll need two sheets in the workbook - one for the 'user interface', and one containing all the personal data, I just have no idea of how to link the two; how data will be retrieved and displayed on the interface sheet; and what format to enter data on the personal data sheet.
Can anyone point me in the direction of a good online tutorial, or give me a basic steer to get me started? I've had a look myself online, but nothing fits the bill. Am I asking too much of Excel?
via International Skeptics Forum http://ift.tt/2f0izka
Aucun commentaire:
Enregistrer un commentaire