I was trying to do an Access database, but maybe a macro would be applicable. Basically, everyday I have to log information about books people take out. This includes personal information that I retrieve from the company phonebook every day. I would use a spreadsheet and put the Book Number, Person's Name who is taking it out, UserID, Supervisor Name, Phone number and building.

What I'm now looking to do is have a macro I click enter a book number in the first column. I then would fill out either the second (UserID) or third column (Username). The name or userid would autocomplete and when I hit enter, the rest of the fields Supervisor Name, Phone Number, Building, etc would automatically be populated. My assumption is that I would have another spreadsheet or workbook with a list of usernames and all the other fields which the main spreadsheet would search and pull from.

Could anybody help me with this? I guess it's just creating a drop down in 2 fields, populated from another spreadsheet or workbook, and the other fields populating accordingly.