adding up rows of text/numbers that are exact matchs

[kerth]

Looking for some help with my code for adding up rows of cells of text mixed with numbers, each row would look like

b1 2 30 10 7/8 Gables 3/4 Pref Birch
b2 2 30 10 7/8 Gables 3/4 Pref Birch
b3 2 30 10 7/8 Gables 3/4 Pref Birch
b4 2 30 10 7/8 Gables 3/4 Pref Birch
b1 1 38 1/2 10 7/8 Base 3/4 Pref Birch
b2 1 38 1/2 10 7/8 Base 3/4 Pref Birch
b3 1 38 1/2 10 7/8 Base 3/4 Pref Birch
b4 1 28 1/2 10 7/8 Base 3/4 Pref Birch

and i would like to make them add up to look like this

b1, b2, b3, b4 8 30 10 7/8 Gables 3/4 Pref Birch
b1, b2, b3 3 38 1/2 10 7/8 Base 3/4 Pref Birch
b4 1 38 1/2 10 7/8 Base 3/4 Pref Birch

code i have currently is:

Please Login or Register  to view this content.

any ideas ? also everything is stored in a .txt file for future use

nevermind, figured it out myself

[Paul]

Hello Kerth, and welcome to the forum.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[kerth]

my appologies, i was in a hurry to get out the door and didnt even realize what i had to do..

[shg]

Post a workbook, kerth.