Hi People,
I hope you are doing good and staying healthy. I am getting addicted to this forum as you people never disappoint me. I am back with another problem that I am trying to solve and need your help and expertise to move forward. Following is my scenario
Problem Statement
In a main folder, I've multiple sub folders (more than 10) and each sub folder have 5 to 8 excel files. What I want is to copy and consolidate data from all the excel files under different sub-folders to one excel file.
Looking forward for a helping hand and thank you in advance.
Best
Varun
PS: I may add more scenarios to this problem later on depending upon the ask from my manager.
Bookmarks