collect data from some files
 

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


--
Newbie80
------------------------------------------------------------------------
Newbie80's Profile: http://www.excelforum.com/member.php...o&userid=25946
View this thread: http://www.excelforum.com/showthread...hreadid=393229

collect data from some files
 

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


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=393229

collect data from some files
 

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

--
Newbie8
-----------------------------------------------------------------------
Newbie80's Profile: http://www.excelforum.com/member.php...fo&userid=2594
View this thread: http://www.excelforum.com/showthread.php?threadid=39322

collect data from some files
 

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

--
Newbie8
-----------------------------------------------------------------------
Newbie80's Profile: http://www.excelforum.com/member.php...fo&userid=2594
View this thread: http://www.excelforum.com/showthread.php?threadid=39322

collect data from some files
 

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Newbie80" wrote in message
...

Would appreciate if someone could atleast tell me how you make a vb
function that reads all data from one worksbook into another workbook's
sheet.
Please someone.


--
Newbie80
------------------------------------------------------------------------
Newbie80's Profile: http://www.excelforum.com/member.php...o&userid=25946
View this thread: http://www.excelforum.com/showthread...hreadid=393229