Hello all! This is my first post but I have looked at the forums before for answers to some other questions so I thank you all for that already. I have made some codes for doing simple things like importing CSV into excel and things like that but now I need some advice on where to get started on this new project, or if it seems to complicated to do. The part of this project that I need help with is how to get my data from all the different folders, once I know how to get my data imported into new workbooks I can figure out the rest. I have attached a file that shows the complexity of retrieving the data that because it is almost too hard to explain via text! What I want to do is import columns D, L, M, and N from each excel file within a two week period which are the highlighted cells in the snipped image.
The top left directory is the file that contains all the workbooks. Then the first layer is 1 - 9 and A and B. Each of these layers have folders within them such as A1, I1, M1.. and so on like the ones listed and within those are all the excel files that I want to process just the ones made within the past two weeks. I want to develop a workbook for each of the first layers and name them SA1 - SA9 and SAA and SAB, within these workbooks I want a worksheet for each of the subfolders such as A1, I1, M1.. and so on and on each of those sheets will have the combined columns of D, L, M, and N from the two weeks worth of sheets. So is this as complicated as it sounds or is it manageable?
One issue is that there are other folders in the 1 - 9, A, B besides A1, I1 and so on so I cant just process every folder. Just the named ones I am interested in. Also, the last 2 weeks of data is not always the same amount of sheets, so I just need to process the sheets from "today - 14 days"
There are some things that I need to do at the end but I believe I can do that, I just don't know how to navigate this tree of folders. Any advice will help!
Excel to help visualize process forum.ozgrid.com/index.php?attachment/69137/