Importing Data from Multiple spreadsheets to one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help. I have a team of about 40 people entering data into
individual spreadsheets. Currently we go to each directory and copy the data
and paste it into a single spreadsheet to send to our corporate office. What
I would like to do is create a spreadsheet that we can go into and import the
data from each individual linked spreadsheet into one. I know exactly how to
do this with access, however our company does not have access. Is there a
way to do it with excel?
 
Have a look at Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the Copy/Paste/Merge examples section specifically on "merging
data" from multiple workbooks to one.

I think his RDBMerge add-in makes it pretty easy.


Gord Dibben MS Excel MVP

On Sun, 22 Jul 2007 15:14:01 -0700, Brent Sweet <Brent
 
Back
Top