I have a requirement in which I want to bring in the data from 4-5 different tabs in an excel file before performing any scrubbing. The header names are same in all the tabs. How can I accomplish this instead of bringing in input tool for each tab?
Thank you. Is there any existing solution that I can look into and configure/create macro accordingly?
You can use batch macro to achieve this
You can try the "Directory.yxzp" workflow referenced in this post by @LordNeilLord:
The workflow consists of two batch batch macros. The first macro extracts the sheet names. The second macro inputs the files.
Give it a try and let us know how it goes!
Thanks,
Deb
Hey man. Just checking if you your issue has been resolved.