NoSparks,

Thanks again for hanging in with me on this one. Its been a bit of a learning curve for me and I'm still hitting a few snags with the actual data set. I ran this new code and it is successful in preserving forecast rows with a column "S" value that is the same as the one above it. Unfortunately when it finds an actual row and a forecast row with matching column S values, it is copying all 12 months from the Actuals column and overwriting data in the forecast column. Its really strange because it works perfectly in the dataset I posted.

I've been trying to figure out what's different, same columns and headers and similar data. Only thing I noticed is my dataset in excel seems to be longer than it is, meaning my scroll bar thinks there's data in about 1000 cells below my actual data. I've tried clearing them and see no values or formulas. But when I Shift-Control-End it includes a bunch of blank cells. Do you think that could be causing the issue?

Also in testing twice the code got stuck at the following line. Not sure why...

.Cells(i - 1, "F").Resize(, firstFcst - 6).Value = .Cells(i, "F").Resize(, firstFcst - 6).Value

Any suggestions where I might go next, I'm hitting a wall on this one. Thanks for your help!