I need to make a spreadsheet for work with several fields. I have inserted
combo boxes into certain columns (last name, first name) so that data can be
easily found. The problem that I am running into is that when I choose let's
say a last name, it separates from the rest of the data but the rest of the
row (first name, date of birth, etc) stays in the original spot. How do I
make it so that I can find data in one column but have all the information in
that row move? I have also seen charts where when the requested data comes up
the rest of the data "hides." If anyone knows how to do that the information
would be greatly appreciated!

Rita