Here is my problem.

I have cells A1:a100 full of numbers.

I wish to select all numbers that are lower than 20 for example and paste
them into cel B1 and down.

I know i could copy and paste but I need more complicated calculations than
that.

THEREFORE is it possible to copy cells based on af statements etc??

Thanks