Forum Discussion
fahadarshad
6 years agoHelper I
How to get specific rows from multiple excel files
Hello everyone I have multiple excel files, with multiple excel sheets. What I intend to do is to go in every sheet of every excel file in a particular folder and only pick out the rows from thos...
- 6 years ago
Try this on for size. I made some assumptions about your data... If you need something different just repost.
Getting Shop List from Excel Workbooks and Sheets
Thanks,
John
v-juanli-msft
6 years agoCommunity Support
Hi fahadarshad
I tried with JohnThomas's method, it works on my side.
Just a little modification to fit my scenario, it works.
If you have any problem, feel free to ask us.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.