collect data from some files

  • Thread starter Thread starter Newbie80
  • Start date Start date
N

Newbie80

Hi,
I have a folder with different excel files and would like to read in
all data from the files in that folder and have the data displayed on a
sheet.
Would like some help with this, would save me alot of time so I don't
need to open every file and copy it in manually.

(Still have to manage the data but this is a first step might try to
improve this so I can get specific data placed on specific places on
the sheet.)
 
You can do this with links. Open a new work book and the first file you
want to get data from. In whatever cell in the new file you want to
start listing the data type =, then go to the first cell in the first
file that you want to copy the data from and click on it, then Enter

You will now have a link between the 2 files, that looks something like
this

=[Filename]WorksheetName!$A$1

The new file will automatically update when you alter the original

To get links to the other cells in the work book, remove the $ sighns
from the formula and click and drag it as far as you need
 
Thanks, but need to have it more automatically need a function tha
reads in all files, no manually work, and displays the data. So nee
some kind of loop that gets the filenames and reads the data an
displays it
 
Would appreciate if someone could atleast tell me how you make a v
function that reads all data from one worksbook into another workbook'
sheet.
Please someone
 
Back
Top