a filter will do this, as will the Range.Find / .FindNext method.


12 columns for months, what distinguishes these from being Actual or Forecast?

A great help here would come from you.
Posting a sample workbook, not all 2000 rows, that is typical of what you're starting with and containing a sheet (manually put together) to indicate what you're wanting to end up with would be extremely helpful towards getting a solution.

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)

Hey NoSparks is this the kind of file you were asking me to post? Any suggestions on a potential VBA solution? Hoping you can help, thnaks!