How do I use Macros to copy select data from one worksheet to another on Excel?

This website should help - http://stackoverflow.com/questions/84331/excel-macro-to-conditionally-copy-rows-to-another-worksheet