Saving Lines / Using a Range in a Drop Down.
 

I've got a couple questions that are bugging me. I'm attempting to create an
In/Out spreadsheet, I've got a rough interface on the front that allows me to
input the information I need for my 20 employee's so I can see at a glance
where they all are.

So I've got Rows named Sally, Bob, Fred, Mr. Friendly etc, and columns
labled In/Out, Notes, Time, Date I want to figure out a way I can save the
information I input into these feilds into a second worksheet that's going to
act like a data base.

My thought is I'd like to have a
Bob / In / 8:15am / 20-May-2007 (save button) That allows me to save JUST
Bob's information to page 2 while ignorning Sally, Fred and Mr. Friendly.
This way I can keep track of where these people are during the day and can
see who left for where when in a history archive.

Any thoughts?

My second problem relates to pulling a 3 column range of information 30 deep
by using a single drop down. So I can access the information in Column 1 and
use that information to auto-fill 2 other columns on the first worksheet from
a data chart I've hidden away on the second page. So basically I click the
Drop Down select Mr. Friendly and it pulls up his Vehicle Cellphone number
and in a second column his Email address and brings this information back to
the first page.

D-Wreck.