Hello,
I have a worksheet using 3 columns (I, J, K) i want to find the duplicates on column J and sum I and K.
Example:
____I____||_______________________J________________________||____K______
1| QTY. || HARDWARE DESCRIPTION || WEIGHT
2| 28 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 10.36
3| || (1) HVY. HEX NUT A563-DH (GALV.) || 5.404
4| || (1) FLAT WASHER F436 (GALV.) || 1.232
5| 116 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 42.92
6| || (1) HVY. HEX NUT A563-DH (GALV.) || 22.388
7| || (1) FLAT WASHER F436 (GALV.) || 5.104
8| 36 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 13.32
9| || (2) HVY. HEX NUT A563-DH (GALV.) || 6.948
10| || (2) FLAT WASHER F436 (GALV.) || 1.584
11| 28 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 10.36
12| || (2) HVY. HEX NUT A563-DH (GALV.) || 5.404
13| || (2) FLAT WASHER F436 (GALV.) || 1.232
I want the vba program to look not for single cell but for range.
For example:
Range ("J2:J4") is a group that are 28 bolts and it has 1 nut for each bolt and 1 washer for each bolt.
Range ("J8:J0") is a group that are 36 bolts and it has 2 nuts for each bolt and 2 washers for each bolt.
but these groups are repeated and I have hundreds repeated I want the vba to look the repeated groups and sum the qty and weight.
The result of aboce should is shown below:
____I____||_______________________J________________________||____K______
1| QTY. || HARDWARE DESCRIPTION || WEIGHT
2| 144 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 53.28
3| || (1) HVY. HEX NUT A563-DH (GALV.) || 27.792
4| || (1) FLAT WASHER F436 (GALV.) || 6.336
5| 64 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 23.68
6| || (2) HVY. HEX NUT A563-DH (GALV.) || 12.352
7| || (2) FLAT WASHER F436 (GALV.) || 2.816
Thank you very much in advance! :D
I have a worksheet using 3 columns (I, J, K) i want to find the duplicates on column J and sum I and K.
Example:
____I____||_______________________J________________________||____K______
1| QTY. || HARDWARE DESCRIPTION || WEIGHT
2| 28 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 10.36
3| || (1) HVY. HEX NUT A563-DH (GALV.) || 5.404
4| || (1) FLAT WASHER F436 (GALV.) || 1.232
5| 116 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 42.92
6| || (1) HVY. HEX NUT A563-DH (GALV.) || 22.388
7| || (1) FLAT WASHER F436 (GALV.) || 5.104
8| 36 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 13.32
9| || (2) HVY. HEX NUT A563-DH (GALV.) || 6.948
10| || (2) FLAT WASHER F436 (GALV.) || 1.584
11| 28 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 10.36
12| || (2) HVY. HEX NUT A563-DH (GALV.) || 5.404
13| || (2) FLAT WASHER F436 (GALV.) || 1.232
I want the vba program to look not for single cell but for range.
For example:
Range ("J2:J4") is a group that are 28 bolts and it has 1 nut for each bolt and 1 washer for each bolt.
Range ("J8:J0") is a group that are 36 bolts and it has 2 nuts for each bolt and 2 washers for each bolt.
but these groups are repeated and I have hundreds repeated I want the vba to look the repeated groups and sum the qty and weight.
The result of aboce should is shown below:
____I____||_______________________J________________________||____K______
1| QTY. || HARDWARE DESCRIPTION || WEIGHT
2| 144 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 53.28
3| || (1) HVY. HEX NUT A563-DH (GALV.) || 27.792
4| || (1) FLAT WASHER F436 (GALV.) || 6.336
5| 64 || 3/4" -10UNC x 2 1/4" LG. HVY. HEX BOLT A325 (GALV.) || 23.68
6| || (2) HVY. HEX NUT A563-DH (GALV.) || 12.352
7| || (2) FLAT WASHER F436 (GALV.) || 2.816
Thank you very much in advance! :D