Hi Everyone
I hope I explain my request as well. I am new to VBA and really need a solution to my problem I have searched the forums but my particular request is not found. Since I do not know how to manipulate VBA code, I would need an exact code for my particular issue.
Here are the facts.
1. I have multiple workbooks [all with the same sheet names] but different saved file names
2. All Sheets in the workbooks have the same data placement format & Data Range
3. The workbooks are all in one folder - name and path will not change
4. I have one MASTER Workbook Sheet - name and path will not change
- Folder path C:\Documents\Folder1
- Sheet name in each workbook that will be used "Sheet1" [without the quotes]
- Data Range that needs to be summed up in MASTER Workbook Sheet [each cell must be summed up individually and the total to appear in MASTER Workbook Sheet] from cell b2 to d4. the same table will exist in the MASTER Workbook Sheet
<tbody>
</tbody>
Where this gets tricky is that I need the code to cycle through each workbook in the folder regardless of name, it must also [if possible] not have to open each workbook but rather to get the data without opening the file [incase the number of workbooks in the folder reaches 1000]
The final result if b2 in each workbook = 1, and there are three workbooks then the MASTER Workbook Sheet total will be 3 at the time of running the code.
I hope someone can help me in this regard
I hope I explain my request as well. I am new to VBA and really need a solution to my problem I have searched the forums but my particular request is not found. Since I do not know how to manipulate VBA code, I would need an exact code for my particular issue.
Here are the facts.
1. I have multiple workbooks [all with the same sheet names] but different saved file names
2. All Sheets in the workbooks have the same data placement format & Data Range
3. The workbooks are all in one folder - name and path will not change
4. I have one MASTER Workbook Sheet - name and path will not change
- Folder path C:\Documents\Folder1
- Sheet name in each workbook that will be used "Sheet1" [without the quotes]
- Data Range that needs to be summed up in MASTER Workbook Sheet [each cell must be summed up individually and the total to appear in MASTER Workbook Sheet] from cell b2 to d4. the same table will exist in the MASTER Workbook Sheet
A | B | C | D | |
1 | Car Name | jan | feb | mar |
2 | BMW | |||
3 | Ford | |||
4 | MAZDA |
<tbody>
</tbody>
Where this gets tricky is that I need the code to cycle through each workbook in the folder regardless of name, it must also [if possible] not have to open each workbook but rather to get the data without opening the file [incase the number of workbooks in the folder reaches 1000]
The final result if b2 in each workbook = 1, and there are three workbooks then the MASTER Workbook Sheet total will be 3 at the time of running the code.
I hope someone can help me in this regard