Help: sort data and move to a new sheet

[DyverDown]

I have a list of students names in columns with their run time and
other physical tests along the row. The sheet uses a vlookup table to
calculate their scores and from their scores, determines if they pass
or fail and if they pass, if they are to receive a fitness pin "Y".
There are columns for each fitness test, a column for their final
score, a column for "Y" or "N" for a fitness pin and a column for
"P"ass or "F"ail.


I would like to copy from the main sheet to another sheet (for
printing) all those students who passed "P" and all those students who
received a fitness pin (either separate new sheets or the same new one)

How can I do this?

HELP...

-Michael

 

[Ron de Bruin]

Hi DyverDown

You can use AutoFilter on the P/F ccolumn and print

Or if you want a seperate sheet see
http://www.rondebruin.nl/copy5.htm

 

[DyverDown]

Thank you... is there a way to do this without deleting the original
data on the sheet (ie: I just want to be able to enter the data on the
main sheet and once in a while print out a report of all students who
have passed, or all students who have a fitness pin)
I do not want to change the original data sheet at all if possible

 

[Ron de Bruin]

Hi DyverDown

The first code example not delete the rows after it copy to the other sheet.
The delete code is commented so it not working on this moment.

But if you only want to print it do a manual AutoFilter on the column and print the sheet