I have been searching the web all day, and I am not sure how to
approach this problem. Here is a basic worksheet:

ID Name Serial #
1 Joe ck9033n2389d
2 Joe 349-283fjrjh55
3 Bob c90320j34n5kjdf
4 Joe kgho95injhs
5 Bob 2353gdf745

Step 1: I have a drop down list with only one instance of each of the
"Name" variable.
Step 2: Upon selecting that name, I would like another drop down box
with all the serial numbers associated with that person.
Step 3: Then, based on the serial number, display stats in the same
row for that item.

Step 2 is what I am having problems with. Any direction would be
extremely helpful. VB? Access? A formula I can't think of?

I would be greatful for any help you could provide.