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