Auto-populate fields from validation list

K

Ken Zenachon

I'm trying to build a worksheet to help organize real estate showings.
One one page - 'Agents' - I'm listing agents and their contact
information, address book-style, with separate columns for first name,
last name, company and so on. A second page - 'Showings' - lists
showing dates, times, and agent information. I want to populate the
agent information columns in a given row using the information already
on page 'Agents' by selecting just, say, his or her first name from a
validation list drop-down menu.

Possible?
If not-- workarounds?

Thanks,

]-[
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top