Hi Hi!

I need some rookie help!

My situation:

I run a youth group, and need to keep track of several hundred kids. I
know Access is the solution to all my problems, but as an interim
solution am trying to figure out a way to do it in excel.

I have one workspace with several sheets.

sheet 1 - list of all participants and their contact information
sheet 2 - copy of all 3rd graders contacts
sheet 3 - copy of all 4th graders contacts
etc...

Goal: I need, while maintain full usability of the first "control"
sheet (sorting, adding new enteries, updating existing etc..), to have
excel to keep track of the data divided by age groups (one of the
parameters on the first sheet)

I tried to use the = sign in the formula field and suggest that row 1
in sheet 2 = row 3 in sheet 1 for example. That didn't work because the
moment I sort the first list differently, the relationship is maintained
with that specific row, and not the specific record.

Help please!! :(


--
tapuza
------------------------------------------------------------------------
tapuza's Profile: http://www.excelforum.com/member.php...o&userid=29864
View this thread: http://www.excelforum.com/showthread...hreadid=495693