Transferring Names between excel sheets

[John]

I am using Excel 2003 to design some registers for multiple college
activities with the front page a summary of students and each subsequent
pages is an activity's register. I would like to input the name of a student
into my first page and then a yes or no desicion based on what activity they
are doing. Based on that Y or N, I would like their name transferred to
relevant register on one of the following pages (this could very well work in
reverse but I don't know which is easier).

On the page the name is transferred to is a list of weeks in the columns
nest to the name with a total at the end. I would like this total transferred
back to the front summary sheet.

 

[Nayab]

I am using Excel 2003 to design some registers for multiple college
activities with the front page a summary of students and each subsequent
pages is an activity's register.  I would like to input the name of a student
into my first page and then a yes or no desicion based on what activity they
are doing.  Based on that Y or N, I would like their name transferred to
relevant register on one of the following pages (this could very well work in
reverse but I don't know which is easier).

On the page the name is transferred to is a list of weeks in the columns
nest to the name with a total at the end. I would like this total transferred
back to the front summary sheet.

U can try following:

Say Main sheet has the structure:

Student Name Act1 Act2 Act3
Alpha Y
Beta Y
Y
Gamma Y

And you have sheets Act1, Act2 and Act3.

Then in each subsequent activity sheets, you have Student Names in
Column A
For Act1 Sheet you can make ColumnA fill with formula for e.g. in A2
you can have =OFFSET(Main!B2,0,-1)
in sheet Act2, your A2 will have =OFFSET(Main!B2,0,-2)
and so on

 

[Dave Peterson]

I'd keep the data in one worksheet and apply Autofilter to it. Then I could use
the dropdown arrow to show just the rows that I want.

But if you want...

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm