I have a large excel file with ~100 tabs. Between each grouping of tabs (by region), I have placeholders with no data but simply the region name to facilitate adding across the file. When I want to edit all of the data tabs at once, I have manually select all of them, or else choose all tabs and deselect my placeholder tabs. I'm wondering - is there a way, outside of macro to create a hyperlink to select all of my data tabs at once?
Thanks!
Chris
Thanks!
Chris