Text

mhamlyn

New Member
Joined
Aug 18, 2006
Messages
14
Here's what I want to do. I'm not sure it is possible, but you all always prove me wrong on that :biggrin:

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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,523
Messages
6,120,042
Members
448,940
Latest member
mdusw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top