Hi,

I have a large spreadsheet with a double header row and merged cells.

For instance:

Row 1: Column A, B, C is merged and has "2010" in it, Column X, Y, Z has "2011" in it.
Row 2: Column A and X = "Plan", Column B and Y = "Released", Column C and Z = "Actual".

I need a macro that will search Row 1 and if it = 2010 then it will delete all the columns that = "Plan", "Released", "Actual"

The catch is this, the columns won't always be the same (it may be A, B, C then the next time it could be D, E, F etc).

So, the macro needs to search row 1 and if it matches 2010 then it searches row 2 and if it finds Plan, Released or Actual it deletes each column.

Hope this makes sense.

Thanks

Dave