Populating Drop Down list from column of entries in another sheet

I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry in, I could have a list of clients to choose from.

The next step, would be to post the log notes/details to a new row, under the corresponding 'indented' row.

Is something like this doable (if what I said is understandable? :-) )


Best Answer