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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
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

Well-known Member
Joined
Jun 27, 2006
Messages
779
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,589
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,034
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,342
Messages
5,641,583
Members
417,223
Latest member
jelena_

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
Top