I've looked around various forums but can't quite get code to work for what I want.
I am using Excel 2003 to do risk assessments. Each risk has it's own row. If there are high or extreme risks I want to copy some of that row over to another sheet.
Risks are listed in rows on a sheet called Risk Assessment
The risks start at row 15
The risk rating is in column H
If the risk rating is High or Extreme I want the row from column A to O copied over to the first available row on another sheet called Action Plan