Hello all:
I am working on a report where I need to SUM amounts in column H, but only those amounts whose ID (located in column A) can be found on a list in a specific sheet of the same workbook. I have 5 additional sheets with lists that contain ID's so I'll use the same piece of code to sum all of these ID's column H values that match ID's in other sheets.
So basically steps are these:
1. Go through column A in the active sheet and look for ID's that match ID's in specific sheet (also located in Column A).
2. If the matching ID is found, use value from the H column of the same row and add it to the SUM.
SUM cell is located 8 cells under the last row in column F, but that's not the problem since I already figured that part out. I am just having difficulties with creating a piece of code to SUM values from cells in column H based on the matching ID's in column A.
Hopefully I made some sense. Let me know if you need more clarification.
Thank you!!!
Bookmarks