Need help with auto moving to worksheet

**Newbman** · 05-15-2009, 01:19 PM

I am a very new excel user, so I apologize if this is a basic question.

I have a data base on a master sheet containing demographic information for all of residents in a building. I want to set up separate sheets organizing the residents by age (one sheet for all of the pople who are 30-40, another for 41-50, etc.). I would like to set up the database so that when I enter one persons demographic data into the master sheet, their row of information will be coppied, and then auto pasted into the sheet that corresponds with their age.

I am sure this is possible, and hopefully it is an easy solution that I am just unfamilar with. Any help would be much appreciated!

Thanks in advance!

**shg** · 05-15-2009, 01:28 PM

If you're creating a database, you specifically don't want to segregate information on different sheets.

**Newbman** · 05-15-2009, 01:32 PM

I want to still keep the master sheet with the entire database for the overall view, but I would like to also separate them by age on different sheets so that I could more easily examine everyone of specific age groups.