Importing Data from Multiple spreadsheets to one

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?
 
G

Gord Dibben

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
 

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

How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
transferring data to new multiple spreadsheets 1
Differences Between Two Spreadsheets ? 1
Display Current Data from Several Spreadsheets????????????? 3
Copy data from multiple worksheets to worksheets in a number of other spreadsheets 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Getting Excel 2007 Spreadsheets to Open Maximized 2
Tranfering data from one spreadsheet to another Automatically 2

Top