Text

[mhamlyn]

Here's what I want to do. I'm not sure it is possible, but you all always prove me wrong on that

I am creating a workbook that keeps track of tests scores, but my principal keeps adding things to it. What I would like to do is create a tab just for a roster of kids, their gender, grade level, Special ed. etc. and then instead of including all of that information into each sheet, just have the different tabs refer to the roster. I think this is kind of like using a database, but I'm not sure.

Any helpers???

thanks

 

[just_jon]

The VLOOKUP function, among others, works well with that type setup, but until we know more about your other sheets it's hard to comment more.

 

[riaz]

It sounds like VLOOKUP will do the job for you. To make life easier, number each kid in the roster. In the test scores sheets, use the same numbers to reference the kids. You can then extract whichever test scores you like for each, all or some kids as you please with VLOOKUP.

I am sure someone more learned than me (that's not too difficult) will come up with a better solution, but this might start you off.

HTH

 

[Peter_SSs]

mhamlyn

Have a look at the VLOOKUP function. You should be able to use it to draw names, gender etc from the 'database' sheet to the other sheets as required.

 

[Joe4]

It DOES sound like a database.

Any chance you have Microsoft Access? If you are building a database, it is a more powerful tool for that type of task than Excel.