collect data from some files

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

 

[Paul Sheppard]

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

 

[Newbie80]

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

 

[Newbie80]

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

 

[Ron de Bruin]

See the examples on my site
http://www.rondebruin.nl/tips.htm