I am trying to develop a macro to find rows in my spreadsheet that share the same account number (in col S), then combine the data into a single row and delete the extra row.

My data resides in columns A-Y and contains twelve months of numerical data (col F-Q) where some rows have Actual values and some rows have Forecast values. In the rows with the Actuals, the forecast months are all zero, and the rows with Forecasts, the actuals months are all zero - no overlapping data. The forecast rows also contain other relevant data in columns A-E so the macro should probably add the Actuals to the Forecast row and delete the Actuals row.

The spreadsheet is typically around 2000 rows long, but the actual size varies each month. And each month the columns containing the Actuals will increase while the columns with Forecasts will decrease until eventually there are no Forecasts. Hoping you can help me solve this

Any help would be greatly appreciated!