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-

所有跟帖： 

• Thanks! But not so sure how I need to change? -pronounced- ♂ (51 bytes) () 09/22/2013 postreply 09:07:04

• 例子里是找到特定的string然后copy到new sheet(其中一个module)，你改成找一个 -asd_123- ♀ (97 bytes) () 09/22/2013 postreply 09:10:01

• 回复：例子里是找到特定的string然后copy到new sheet(其中一个module)，你改成找一个 -smartyathene- ♀ (91 bytes) () 09/27/2013 postreply 15:46:04

• If and vlookup. -julie116- ♀ (0 bytes) () 09/22/2013 postreply 17:30:55

• i'm afraid this cannot eniminate amount with 0 -pronounced- ♂ (16 bytes) () 09/22/2013 postreply 17:51:25