Is there a way to read in, for example, I have an Excel which has 3 sheets "Flow, Non-flow & Seat number" and I want to read in 2 sheets "Flow & Non-flow" without "seat number"?
@Akeelah yes, this is possible first use the input tool to pull sheet names only then apply a filter to remove the unwanted and then use Directory tool to read the required.
just use a batch macro. as @binuacs shows - use a batch macro for this. don't use dynamic input.
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
