Hello,

I have come across this in the distant past, and cannot for the life of me figure out how to do it:

I have a drop down list of employee names. I wish to populate the sheet with each employee personalized data when I select the name.

For example:

The sheet has a header row of months of the year. The first column would have a drop down of the names list. Selecting the name would populate the row underneath the months with visited locations, if any, per month. Adding a visit would naturally have to be retained, when later on the same employee visits another location. It would be a set amount of locations that can be chosen from.

Is this possible?

Thank you for your help.