Macro to copy data from one excel work book and pase it in another

Hi

I have Excel workbook (Data) and another workbook (Result).
Data workbook contains names and value for example:

ColumnA , ColumnB
Names , values
Apple01, 10
Apple20, 20
Orange01,30
Orange50,30
Orange, 45
Apple , 47

I need to write a macro which gives me a button and when I press it, it copies data from ColumnA where Name field contains any numeric value , as above it should only select Apple01,Apple20,Orange01 and Orange50
with their values and paste it in Workbook (Result).

Thanks for your help.

James

Here, try this:

Please Login or Register  to view this content.

Hi

Thanks so much guys. Stupid question probably , how to copy pase this macro in excel . second do I need to do this coding in DATA workbook or RESULTS workbook. Also do I need to keep both these workbook in same directory.

Thanks

James

those are sheets in your workbook, not a different workbooks.

Check here how to add macro: http://office.microsoft.com/en-us/ex...005204711.aspx

Hi

Sorry maybe I was not very clear earlier. I have two excel workbook(DATA.xlsx and Result.xlsx). They are not two sheets in one workbook. One excel file contains records which I need to select only those records which has numeric value in name column and paste in another excel file ( RESULT.xlsx).
This mechanism should be triggered when I press Button in RESULT.xlsx .

Hope it helps you . I am novice to visual basic or vb script. Your help is much appreciated.

Thanks

James

Hi
Thank you Master!!!. Its working great...
Only change I had to make was on this line of code

Please Login or Register  to view this content.

I see from your code if numeric value appears at the end of string and its two digit long , it gets selected. How difficult is to look for any numeric value in a string and if its find one , copy and paste it on Results.xlsx file.

Many thanks

James

Many Thanks for your help. Work great !!!!