Is there a macro that will look for duplicate rows across columns C thru G and if a duplicate or duplicates are found to sum the numbers in column H of their row in column B of their row?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
This is an example:<o></o>
The colors are here only to represent duplicates and are not normally on the sheet.<o></o>
Before macro is executed:<o></o>
<o>
</o>
<o></o>
After macro is executed:
Thank you for your help
Charlie
This is an example:<o></o>
The colors are here only to represent duplicates and are not normally on the sheet.<o></o>
Before macro is executed:<o></o>
<o>
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | ThelmaCode | ThelmaSumDuplicates | ThelmaEaLft | ThelmaPieceSize | ThelmaMaterialUsed | ThelmaStudBearing | ThelmaFloor | ThelmaSumLFT | ThelmaCornerChannel | ||
2 | 0 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 33 | 7 | |||
3 | 0 | Ea | 2X4 | 9 STUD GR DF KD C/L | 2x4 NON-BEARING STUDS | 1st Floor | 22 | 6 | |||
4 | 0 | Ea | 2X4 | 22 #2 DF S4S | 2x4 NON-BEARING STUDS | 1st Floor | 12 | 2 | |||
5 | 0 | Ea | 2X4 | 22 #2 DF S4S | 2x4 NON-BEARING STUDS | 1st Floor | 11 | 2 | |||
6 | 0 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 33 | 14 | |||
7 | 0 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 BEARING STUDS | 1st Floor | 21 | 12 | |||
8 | 0 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 2nd Floor | 44 | 23 | |||
9 | 0 | Ea | 2X4 | 9 STUD GR DF KD C/L | 2x4 NON-BEARING STUDS | 1st Floor | 12 | 2 | |||
10 | 0 | Ea | 2X4 | 9 STUD GR DF 104 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 11 | 2 | |||
11 | 0 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 21 | 4 | |||
12 | 0 | Ea | 2X4 | 8 STUD GR DF 92 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 56 | 33 | |||
13 | 0 | Lft | 2X6 | 10 STUD GR DF 116 1/4 KD | 2x6 NON-BEARING STUDS | 1st Floor | 21 | 4 | |||
14 | 0 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 1st Floor | 41 | 21 | |||
15 | 0 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 1st Floor | 12 | 1 | |||
16 | 0 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 2nd Floor | 14 | 2 | |||
Thelma |
<o></o>
After macro is executed:
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | ThelmaCode | ThelmaSumDuplicates | ThelmaEaLft | ThelmaPieceSize | ThelmaMaterialUsed | ThelmaStudBearing | ThelmaFloor | ThelmaSumLFT | ThelmaCornerChannel | ||
2 | 0 | 87 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 33 | 7 | ||
3 | 0 | 121 | Ea | 2X4 | 9 STUD GR DF KD C/L | 2x4 NON-BEARING STUDS | 1st Floor | 22 | 6 | ||
4 | 0 | 23 | Ea | 2X4 | 22 #2 DF S4S | 2x4 NON-BEARING STUDS | 1st Floor | 12 | 2 | ||
5 | 0 | 23 | Ea | 2X4 | 22 #2 DF S4S | 2x4 NON-BEARING STUDS | 1st Floor | 11 | 2 | ||
6 | 0 | 87 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 33 | 14 | ||
7 | 0 | 21 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 BEARING STUDS | 1st Floor | 21 | 12 | ||
8 | 0 | 44 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 2nd Floor | 44 | 23 | ||
9 | 0 | 34 | Ea | 2X4 | 9 STUD GR DF KD C/L | 2x4 NON-BEARING STUDS | 1st Floor | 12 | 2 | ||
10 | 0 | 11 | Ea | 2X4 | 9 STUD GR DF 104 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 11 | 2 | ||
11 | 0 | 87 | Ea | 2X4 | 10 STUD GR DF 116 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 21 | 4 | ||
12 | 0 | 56 | Ea | 2X4 | 8 STUD GR DF 92 1/4 KD | 2x4 NON-BEARING STUDS | 1st Floor | 56 | 33 | ||
13 | 0 | 21 | Lft | 2X6 | 10 STUD GR DF 116 1/4 KD | 2x6 NON-BEARING STUDS | 1st Floor | 21 | 4 | ||
14 | 0 | 53 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 1st Floor | 41 | 21 | ||
15 | 0 | 53 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 1st Floor | 12 | 1 | ||
16 | 0 | 14 | Ea | 2X6 | 10 STUD GR DF 116 1/4 KD | 3x6 BEARING STUDS | 2nd Floor | 14 | 2 | ||
Thelma |
Thank you for your help
Charlie