Registration is open for Inspire 2024! For today only receive up to 20% off. This promotion is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes. Register here!
I am able to use batch macros to input different files with same sheet names, but how do I do it with different sheet names with different files? So i want to be able to pick up a particular sheet among multiple sheets with different sheet names and different file names, the only similarity i can see in the sheet names that i want to input in from all different files is the first word of the sheet name.