rkol297
Board Regular
- Joined
- Nov 12, 2010
- Messages
- 131
- Office Version
- 365
- 2019
- Platform
- Windows
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
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