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

Similar Threads

Drop-down List Array 2
AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED 0
SUMIF with NAME RANGE 1
"Sort by" issue 4
Auto populate from list on separate sheet 3
Second request! Select two records from same table, autopopulate f 5
Validation list populating multiple cells 4
Need to populate data from different sheet. 1

Top