Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Sorting Problem
I have student information on two sheets, attendance and testing information.
Students' names and numbers are only entered on the testing info. sheet, but are referenced on the other sheet. Students' status is entered on the attendance sheet and reference on the other. Just in case it would make it any easier to sort, I've made the row numbers on both sheets the same for each student. Is there a way to group the two sheets and sort the rows simultaneously, so the cell references don't get out of order? I would appreciate any advice on this complicated sorting problem. Here are the basic sheet setups *Refers to sheet 1 **Refers to sheet 2 SHEET1 A B,C D...P Q R S....IV Number** Name** Attendence Sums Progress** Status Hours/Date SHEET2 A B C,D E F........ Status* Number Name Progress TestingScores Thank you for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Sorting Problem
Hi Stacy,
It sounds like you have straight cell references like "=Sheet1!A1". Have you had a look at the VLOOKUP function in Help? That would be the place to start, as it also sounds like it can handle what you need to do, so that your references don't get messed up. I hope this is helpful, Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Sorting Problem
Just to complicate things more, I forgot to mention the rows are first sorted
by status then by names. "stacyjhaskins" wrote: I have student information on two sheets, attendance and testing information. Students' names and numbers are only entered on the testing info. sheet, but are referenced on the other sheet. Students' status is entered on the attendance sheet and reference on the other. Just in case it would make it any easier to sort, I've made the row numbers on both sheets the same for each student. Is there a way to group the two sheets and sort the rows simultaneously, so the cell references don't get out of order? I would appreciate any advice on this complicated sorting problem. Here are the basic sheet setups *Refers to sheet 1 **Refers to sheet 2 SHEET1 A B,C D...P Q R S....IV Number** Name** Attendence Sums Progress** Status Hours/Date SHEET2 A B C,D E F........ Status* Number Name Progress TestingScores Thank you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting complex worksheets | Excel Worksheet Functions | |||
Complex Array sorting issue | Excel Worksheet Functions | |||
Complex Sorting | Excel Discussion (Misc queries) | |||
Complex Sorting Problem | Excel Worksheet Functions | |||
complex column sorting | Excel Programming |