Good evening!
I need to link a blank column from an alphabetized list of students (the All Students by Last Name) to the same titled column on individual sheets by grade (there are 11 of them PreK-3 to 8th Grade) so that when I put either yes or no in the column on the master list of students sheet it updates the Student by Individual Grade sheets.
I have made another sheet All Students by Grade in case it's easier to link it to the individual sheets by grade.
Right now the thought of doing an = and matching it to each cell does not thrill me.
STJES
Try a Vlookup formula. If your first sheet is called Master and the list is A1:B100, on your other sheets, you could have in column B, =Vlookup(A1,Master!A1:B100,2,0), then copy and drag down. If your sheet name is more than one word, you need to surround it with ' marks, as in 'This is the master'!A1:B100.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks