Importing Data from Multiple spreadsheets to one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brent Sweet - 22 Jul 2007 23:14 GMT

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?

Reply to this Message

Gord Dibben - 22 Jul 2007 23:46 GMT

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

>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
[quoted text clipped - 3 lines]
>do this with access, however our company does not have access. Is there a
>way to do it with excel?

Reply to this Message