Hello all...

I have a spreadsheet that's used to track a person's events accomplished and to let them know how many events of each type they have left to accomplish for the next month. Here's an example of the data in the spreadsheet:

The ID column is typed in and used to match imported data from a much larger training database. Once matched, the number of events remaining for the selected person is calculated and put into the "Rem" column. This works as I need it to. However, we have several events that can be double-logged. That is, you need to accomplish a combined total of 6 events of Type 2 and Type 3. You're allowed to do any combination of the two to meet your minimum event count. I have another worksheet that lists which events are double logged. In the above example, it looks like you need 6 Type 2 Events and 0 Type 3 where in reality I would need a combination of the two totalling 6 to meet my minimum requirements. I need to be able to search the spreadsheet that lists the double-logged events and if it's found there, find those events on the main reporting spreadsheet. Once they're found on the main spreadsheet, I'd like to determine if the events are next to each other on the spreadsheet (they usually are) and, if so, merge the two cells so it's a little more obvious to the user that the events are combined for logging purposes.

In the above example, as I step through each ID cell, I want to find SC09 on the double-log spreadsheet. Once found, I want to determine what event can be double-logged with it (SC02). I then need to find SC02 on the spreadsheet and if SC02 is next to SC09 on the main spreadsheet, merge the two cells (B3 & B4 in this case) and put the value (6) in that merged cell.

I'm familiar with coding in VB (mostly Access, but some Excel).

Any help on this matter? Thanks in advance.