B
Burke
Hello everyone,
First of all, thank you all for the support that you give to us
inexperienced users. Here's my dilemna: I have a list of employees in an
Excel worksheet (named "Employees"), that lists names, addresses, numbers,
birthdates, etc. This list is 247 rows.
I have another worksheet called "Flight Reservations" where I want to click
in the first column of the first row and select a name from a drop down list
that i want to create (or a lookup list, etc). When I select that name, I
want all the other information (from the worksheet named "Employees") to fill
in the remainder of the row with the rest of the information from that
employee. I tried to create a regular Drop Down list/box, but it only inputs
the foirst column of my list, and not the remainder of the information for
that employee. Having said that, I want the ability to do that task with each
subsequent row, thereby listing several employees who will be flying out on
that manifest reservation form. Any suggestions? Thank you, Lee
First of all, thank you all for the support that you give to us
inexperienced users. Here's my dilemna: I have a list of employees in an
Excel worksheet (named "Employees"), that lists names, addresses, numbers,
birthdates, etc. This list is 247 rows.
I have another worksheet called "Flight Reservations" where I want to click
in the first column of the first row and select a name from a drop down list
that i want to create (or a lookup list, etc). When I select that name, I
want all the other information (from the worksheet named "Employees") to fill
in the remainder of the row with the rest of the information from that
employee. I tried to create a regular Drop Down list/box, but it only inputs
the foirst column of my list, and not the remainder of the information for
that employee. Having said that, I want the ability to do that task with each
subsequent row, thereby listing several employees who will be flying out on
that manifest reservation form. Any suggestions? Thank you, Lee