Extarct limited Excel data from D drive to another excel file

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I access the access data via Excel 2002 with auto update ? 1
Attach Files Listed in Columns with Email 7
open excel file and copy data to another file 4
Refresh Bloomberg data in an excel file from a script 4
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog 3
Copy Data from Closed File to Existing File 0
get Data Validation to stop, list supplied, duplicate data entries 1
Can't Open Text File From Website in Excel 2010 0

Top