I
imafellow
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,
]-[
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,
]-[