I have the following code below that will sum the values from multiple sheets based on a specific group ID. in the attached example i have group "1-1" in cell I12 with 2 values in cells K25 & K27. the next group is "1-2" ub cell I35 with its values in cells K48 & K50, the 3rd group repeats ID "1-1" with additional values. The code will sum the values for similar group ID's. So the values for group 1 & 3 will be combined on the "DATA CHECK" worksheet.
The issue i have is the there is additional text in column I from worksheet "1-30" that is being copied over to the "DATA CHECK" worksheet. currently if i keep everything as it is (with the duplicated text), the code works fine. But if the text if column I is changed or the text on the DATA CHECK worksheet is changed the code stops working correctly.
Basically i would like the text not to be copied over and only the values to be summed per their corresponding group ID.
Bookmarks