automatically move entire row by cell validation
 

Hi all,

Hopefully someone can help.
I am trying to move an entire row by a specific cell validation. If cell A3 describes 'declined', i want excel to move that entire row 3 to 300. So my sheet will be easier to read, but the data is still there. The cell in A3 (and below) is currently a drop down list (maybe that will influence).

Thanks!
Nynke