Good Morning!
I am trying to use a name manager for easier data retrieval from various worksheet. Since more worksheet is going to be added, I am wondering if there is an algorithm that reference to all worksheets that contains same text in the name.
For an example, I want to expand my range to all worksheet containing term "January" in the tab name, so I can expand the range to include January Shift Report, January Inventory Report, January 22nd 2015 etc.
Basically, in the name manager, I want the range to automatically include any extra worksheet with a specific text in the name.
If possible.
Bookmarks