I have a worksheet with multiple columns, always the same quantity, rows that will vary in number. I need to search the rows finding a matchup in 4 specific columns ex.( B, C, G, & H). Those rows that match need to be combined. Once combined I need the ones that matched to be removed.

Example.

Tom | Red | 5 | 2008 | 16
Tom | Red | 5 | 2008 | 12

output: With the two found rows removed(deleted).

Tom | Red | 5 | 2008 | 28

This will need to cycle through the complete list of rows containing information.

Thank U