NoSparks,

Been using this code to build report for the past week and came across an issue. The example data didn't reflect a few new scenarios I found in a few reports. In the original data all consecutive rows with the same account number in col S where forecast and actuals rows where the code then combined them and and then deleted the actuals row. Now I also have consecutive rows with the same account number where then are (1) two forecast rows followed by an actuals row, and (2) two forecast rows with no actuals row. In both of these scenarios the second forecast row is getting deleted. Can the code be modified to not delete second row unless its an actuals rows that has been combined withe a forecast row? I will attach a second example. Thanks!