I would like to link students for the 1st Nine Week list to the correct grade level as shown. I have attached a file I hope it helps.
I would like to link students for the 1st Nine Week list to the correct grade level as shown. I have attached a file I hope it helps.
Last edited by Wskip49; 08-31-2009 at 10:54 AM.
Click on the "+" sign just above column K to unhide/hide the "key" columns I added to make this clean and easy. It's a set of columns "Indexing" the rows by grade choice.
Then on the other sheets, we are counting the number of students per grade and putting that in cell C1. Then the column A formulas are using that number in C1 to go get that number of student IDs from the first sheets.
The rest of the grade sheets pull their information off of the IDs that appeared.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This is great. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks