Hello,
Is there a way similar to the inout file where you can put an asterisk in to pull the beginning words of a file- to do the same for the sheet name where i want the formula/ dynamic input tool to pull a specific sheets beginning.
ex: sheet name is : “my hallway 01”
I only want it to look for my hallway and ignore the 01 as tomorrow when i run it the file could have my hallway 02 as thr sheet name
Solved! Go to Solution.