Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
I am in need of collecting data from multiple workbooks, typically with just 1 sheet, and combining it on one form for easy viewing.
I am unsure of how to start this. The workbooks all have unique names with no pattern at all, but are all in the same folder.
For the sake of ease for an example:
Folder1 has 3 workbooks.
workbook1.xls
somebook.xls
dataofsomekind.xls
Each workbook has data in the same cells that I need to collect.
A1
A2
A10
A11
I would like the data put into a new workbook in the following way.
NewWorkbook.xls
A1 = workbook1
B1 = workbook1.cell(A1)
C1 = workbook1.cell(A2)
D1 = workbook1.cell(A10)
E1 = workbook1.cell(A11)
A2 = somebook
B2 = somebook.cell(A1)
C2 = somebook.cell(A2)
D2 = somebook.cell(A10)
E2 = somebook.cell(A11)
etc.
Thank you in advance for the help.
Simi
I am unsure of how to start this. The workbooks all have unique names with no pattern at all, but are all in the same folder.
For the sake of ease for an example:
Folder1 has 3 workbooks.
workbook1.xls
somebook.xls
dataofsomekind.xls
Each workbook has data in the same cells that I need to collect.
A1
A2
A10
A11
I would like the data put into a new workbook in the following way.
NewWorkbook.xls
A1 = workbook1
B1 = workbook1.cell(A1)
C1 = workbook1.cell(A2)
D1 = workbook1.cell(A10)
E1 = workbook1.cell(A11)
A2 = somebook
B2 = somebook.cell(A1)
C2 = somebook.cell(A2)
D2 = somebook.cell(A10)
E2 = somebook.cell(A11)
etc.
Thank you in advance for the help.
Simi