Can excel gather data from every work book in a folder?

**McCool** · 07-21-2013, 09:10 PM

Hello,

I am wondering if I can make an excel program that will automatically take data from a specific cell from every work book within a folder.

As an example;

I want to gather all of the information from cell A27 in the "Invoice" sheet of every work book within a folder and have it put into its own cell in a completely separate work book.

Thank you.

**Ariff_Chowdhury** · 07-21-2013, 09:21 PM

Perhaps the below link will help you
http://www.rondebruin.nl/win/section3.htm

**McCool** · 07-22-2013, 12:18 AM

Thank you for the link, I looked through it and I think I found what I am looking for but I am new to Macros. Do you have another link where I can get some info on how to use them.

I tried installing one but it didnt seems to work.

**arlu1201** · 07-22-2013, 06:12 AM

If you post a sample file, someone will be able to help you -

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.