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!
Bookmarks