Select certain numbers high and move them to another column (VBA code)

I need to look through column B at dollar amounts, I need only the ones that are $500 or more and place their values in column E. Also I need to take their name of the user in column A as well but the names will be in column D.

Thanks in advance.

Add a help column first.

Eg

in E2 enter:

=IF(B2>=500,COUNT(E$1:E1)+1,"")

copied down

Then in a separate column, one cell, say in F2, enter =MAX(E:E)

To extract data now...

=IF(ROWS($A$1:$A1)>$F$2,"",INDEX(A:A,MATCH(ROWS($A$1:$A1),$E:$E))

copied down as far as you want...

Then copied across to get Column B, C, D corresponding values.

Perhaps someone else can....