Import data from other Excel file if file ends with "[directory][filename].xls"

S

skusey

Hi everyone, need some help (obviously)....

I have a folder with many different types of Excel files. There are
many different Excel files with many different types of filenames
however, there are a number of Excel files within the folder that end
with "Rescan Errors.xls" and I want Excel to import the data from the
"Rescan Errors.xls" files into a "DCC MI.xls" file.

I want data from cell "B4" in the "Rescan Errors" file to be dropped
into cell A1 in the "DCC MI" file.

Obviously, I have no idea on how to do this and would like some help if
poss.

Many thanks in advance for your 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

Import 4 Different Excel Files from One Folder 0
A code to import other xls data into one xls file 3
Not saving as xls file 1
Forcing Excel to Import .CSV data 2
Excel 2011 Mac - Import Worksheets into a Single File 0
Import data from multiple txt files into one xls file 3
How check if file to open is Excel or if Excel file is corrupt? 3
get complex data from other xls file 2

Top