Extarct limited Excel data from D drive to another excel file
 

I need a macro which will extarct the data in another excel workbook
if i select "March" then macro will ectract the data from "D" drive
find out the file which maches the name and extract the limited data
from the drive file to the "March" file.

Exmaple -: In "D" drive i have a file named as march 2010 which has
100 columns.
and in another file where i need the data where i have applied a
validation which has file names where if i select "march" then macro
immediatly serach the file in "D" drive and give me the data for
selective cells.Please help...

Extarct limited Excel data from D drive to another excel file
 

What do you have so far ?

Tim

"richa Jacob" wrote in message
...
I need a macro which will extarct the data in another excel workbook
if i select "March" then macro will ectract the data from "D" drive
find out the file which maches the name and extract the limited data
from the drive file to the "March" file.

Exmaple -: In "D" drive i have a file named as march 2010 which has
100 columns.
and in another file where i need the data where i have applied a
validation which has file names where if i select "march" then macro
immediatly serach the file in "D" drive and give me the data for
selective cells.Please help...