Hi,

I'm creating an excel workbook, that has information about stats from my
football team. One sheet has ALL the information (stats), and another sheet
is my overview sheet with only pertinent information that we want to see. On
the second sheet (overview sheet), the information is broken up into player
positions (ie. Quaterback stats, then running back stats, etc). On sheet 1
(with all the data), it is in alphebetical order and we want to keep it like
that. The problem I am having is that if I add or delete a player on Sheet 1,
it screws up my overview sheet, because now I have running backs in the
quarterback section, and so on throughout the entire sheet.

Is there a way to set up my overview sheet so that when I add or delete a
player in sheet 1, the categories (ie. Quaterback stats) on sheet 2 remain in
tact, without a shifting of records? Also, is there a way so that when I add
a player in Sheet 1, it will automatically categorize that player into their
respective category in sheet 2?