Copy partial rows based on value

Hello,

I'm hoping someine can help me...
I'm new to visual basic and I'm looking for a code to take the data from an excel spreadsheet, sheet 1 and place the data into a new sheet; sheet 2, but only if the value in column f is > than 10 if this value is < 10 i want it to ignore it and go to the next value and loop until all information with values greater than 10 are pasted into the new sheet (sheet 2), The value in column f is calulated bassed on the aswer given in column d.
I am trying to have this function performed at the click of a button.

I hope i haven't made this too complicated...

Thanks in advance,

Mick

P.S. running office 2003