Need to pull values from different sheets by referencing adjacent names...

vanhoand

New Member
Joined
Sep 12, 2014
Messages
2
I'll try to make this as straightforward as possible. Using Win7, Office2010.

I have a spreadsheet with multiple worksheets (for different days) that lists the names of students and then a total amount due for each student next to those names for each day. The names in each spreadsheet are not always the same and are not always in the same order. In a separate worksheet, I need to sum the total due for each individual name from all of the other worksheets.

So for example, if I'm trying to sum all the amounts due for Jane Doe from each worksheet, I can't just pull and sum values from B5 (assuming that's where she is listed in the 1st worksheet) because on subsequent sheets, her total due for that day might be down at B7 or some other cell in that column. It will be in the same column though.

I know I could filter each worksheet alphabetically to at least get all the names in a common order, but that solution doesn't work if the exact same number of student names are above her in each worksheet (which would be unlikely).

What would be the best way to do this? I'm guessing a script would be ideal but I'm a novice in terms of writing them.

Thanks!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

vanhoand

New Member
Joined
Sep 12, 2014
Messages
2
OK thanks. I'll look into those. Are there different types or something more specific I should look at?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,297
Messages
5,836,481
Members
430,434
Latest member
whatabout

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