Here's an example of the file I am trying to combine. In column S I have created a field that combines three attributes (dept, acct and vendor) into one value. If this value exists is consecutive rows, and the two rows contain no data in overlapping months (i.e., typically the first row is forecast data and the second is actuals data with no overlapping months), then the code should copy the actuals data into the forecast row and delete the actuals row. The code needs to work regardless of which months are actuals and which are forecasts as that will change each month. Hope this helps clarify what I'm trying to do.

I appreciate your help!

Attached Files

Example data.xlsx (17.6 KB, 10 views)