ThriftyBrewer
New Member
- Joined
- Feb 17, 2016
- Messages
- 3
Hi All,
I'm hoping I might be able to get some assistance with a macro. I searched the forums before posting, but I couldn't seem to find an existing post that addresses exactly what I need.
I have roughly 1,000 excel files, all stored in the same folder, from which I need to capture data and summarize on one sheet. Specifically, I would like each file to be represented as one row on the summary document, with the four data elements I'm looking to capture stored in columns A through D. On the worksheets I'm looking to extract from, the data I need is stored in cells B3, B35, B36, and B37. All the workbooks have different names, but the name of the sheet I want to pull the data from is the same for every file.
I greatly appreciate any assistance that anyone is able to offer. Please let me know if more detail is required.
Thanks!
I'm hoping I might be able to get some assistance with a macro. I searched the forums before posting, but I couldn't seem to find an existing post that addresses exactly what I need.
I have roughly 1,000 excel files, all stored in the same folder, from which I need to capture data and summarize on one sheet. Specifically, I would like each file to be represented as one row on the summary document, with the four data elements I'm looking to capture stored in columns A through D. On the worksheets I'm looking to extract from, the data I need is stored in cells B3, B35, B36, and B37. All the workbooks have different names, but the name of the sheet I want to pull the data from is the same for every file.
I greatly appreciate any assistance that anyone is able to offer. Please let me know if more detail is required.
Thanks!