Data sheets on different Tabs, pull a value from each tab for a specific value

rkol297

Board Regular
Joined
Nov 12, 2010
Messages
125
I have 18 sheets all formatted the same:

Column B is a persons name, Column L is a metric that I'm pulling.

I have a list of names on sheet 19 that lists the names in column A that matches the names in Column B on all the other Sheets.
What I need to do is pull the metric from each of the first 18 sheets and place them in the same row for the name on sheet 19 with the metrics being added for each sheet from column C through T.

Can this be done with a VBA macro?


Final result would look like:

Column B Column C Column D etc....

Name metric1 metric2
Name metric1 metric2
Name metric1 metric2
Name metric1 metric2
Name metric1 metric2
Name metric1 metric2
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Webbarr

Board Regular
Joined
Jun 26, 2015
Messages
88
Hi,

Sorry to ask but does this HAVE to be done in VBA? It sounds like a very simple solution that a vlookup or Index could solve.
 

rkol297

Board Regular
Joined
Nov 12, 2010
Messages
125
Hi,

Sorry to ask but does this HAVE to be done in VBA? It sounds like a very simple solution that a vlookup or Index could solve.


I guess not but the other sheets are going to manipulated as far as a sort function within those sheets how would I do this with the vlookup or Index and still be able to move the order of cells around on the other sheets?
 

rkol297

Board Regular
Joined
Nov 12, 2010
Messages
125
Are the names unique in each sheet or do you have duplicates?


Names would be the same name options on each sheet; but wouldn't be in the same order but would be in the same column on each sheet

Example
Sheet 1 sheet 2

bill terri
dave bill
terri jill
jill jack
jack dave


The metric is a number that is always in the same column on each sheet
I would just need to be able to rely on the fact that if the sheet gets sorted the summary sheet would find the name and corresponding metric no matter what order the sheet is sorted by as there are other values that are looked at in other columns.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,649
Messages
5,597,368
Members
414,139
Latest member
okela0

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