Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: sort data and move to a new sheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort data and move to a new sheet
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DyverDown" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort data and move to a new sheet
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 wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DyverDown" wrote in message ups.com... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort data and move to a new sheet
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DyverDown" wrote in message oups.com... 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 wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DyverDown" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
Sort data and move to next 5 column | Excel Programming | |||
Sort data and move to next column | Excel Programming |