Quote:
I am trying to develop a macro to find rows in my spreadsheet that share the same account number (in col S)
|
a filter will do this, as will the Range.Find / .FindNext method.
Quote:
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.
|
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.