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