Hi, I'm trying to do the followings using VBA:
Part 1 - split my worksheet into multiple workbooks
Part 2 - save that workbook into a folder based on the cell value
An illustration of the format of file is as below:
Basically I'm splitting the worksheet based on the branches (Col C), but would like to save the new workbook (by branches) into the folder which is by regions (Col B).
I have found some code on splitting the worksheet based on cell value but was not able to get the Part 2 done.
Appreciate any input and hopefully my ending goal is understandable. -Thanks!
Part 1 - split my worksheet into multiple workbooks
Part 2 - save that workbook into a folder based on the cell value
An illustration of the format of file is as below:
| No. | Regions | Branches | Customer Name |
| 1 | Region1 | A | Ken |
| 2 | Region1 | A | Ash |
| 1 | Region1 | B | Dave |
| 1 | Region2 | C | John |
| 1 | Region2 | D | Marcus |
| 1 | Region3 | E | Albert |
Basically I'm splitting the worksheet based on the branches (Col C), but would like to save the new workbook (by branches) into the folder which is by regions (Col B).
I have found some code on splitting the worksheet based on cell value but was not able to get the Part 2 done.
Appreciate any input and hopefully my ending goal is understandable. -Thanks!
