see this example inside

you need to change it to copy numbers though

http://www.davesexcel.com/apps/blog/show/5480104-how-do-i-find-data-in-a-column-then-copy-and-paste-it-to-a-new-location-