Extarct limited Excel data from D drive to another excel file

  • Thread starter Thread starter richa Jacob
  • Start date Start date
R

richa Jacob

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...
 
Back
Top