Hi all,

Im sure this is pretty simple but cant figure it out for the life of me...

All I require is either a code or formula that will recognize if there is a '1' in Column AH of 'Sheet1' and if so copy and paste the row containing the '1' into 'Sheet4'. This row can then be deleted from 'Sheet1'.

Thanks for any answers in advance..