rockchalk33
Board Regular
- Joined
- Jan 12, 2016
- Messages
- 111
Hey all,
So I am stuck on quite a large project. I have a sheet with a list on names in column A...the rest of the columns (B through I) are numerical values associated with that name.
Here's the rub...there could be only the one one, two, or even up to twelve different rows all containing the same name but different numerical values in the respective columns.
I need to a subroutine to add up all the values in columns "B" that have the same name in column A, columns "C" that have the same name in columns A, repeating this process through column "I"....while simultaneously deleting the row after the summation has occurred.
I can't seem to figure this one out at all and can't find any answers online. PS the data will already be in alphabetical/numerical order
Thanks for the help!!!
Example:
Devin 1 2 3 5 7
Jorden 2 2 2 2 2
Jorden 3 4 7 7 2
Jorden 0 1 1 1 2
Jorden 1 1 2 3 4
Lydia 5 7 9 0 3
Lydia 1 1 1 6 9
Phil 2 7 9 1 0
Would ultimately look like this (without any spaces between rows):
Devin 1 2 3 5 7
Jorden 6 8 13 13 10
Lydia 6 8 10 6 12
Phil 2 7 9 1 0
So I am stuck on quite a large project. I have a sheet with a list on names in column A...the rest of the columns (B through I) are numerical values associated with that name.
Here's the rub...there could be only the one one, two, or even up to twelve different rows all containing the same name but different numerical values in the respective columns.
I need to a subroutine to add up all the values in columns "B" that have the same name in column A, columns "C" that have the same name in columns A, repeating this process through column "I"....while simultaneously deleting the row after the summation has occurred.
I can't seem to figure this one out at all and can't find any answers online. PS the data will already be in alphabetical/numerical order
Thanks for the help!!!
Example:
Devin 1 2 3 5 7
Jorden 2 2 2 2 2
Jorden 3 4 7 7 2
Jorden 0 1 1 1 2
Jorden 1 1 2 3 4
Lydia 5 7 9 0 3
Lydia 1 1 1 6 9
Phil 2 7 9 1 0
Would ultimately look like this (without any spaces between rows):
Devin 1 2 3 5 7
Jorden 6 8 13 13 10
Lydia 6 8 10 6 12
Phil 2 7 9 1 0