This is cool, @jpfieber.
Personally, I had managed my tags in more of a top-down architectureâ with a hardcoded Tags (definition) sheetâ but I think your approach of gathering tags as they exist in multiple sheets and consolidating them is pretty clever. Itâs easy to use.
Only suggestionâ and feel free to take it or leave it⌠I really like the way you implemented the start/end cell lookups in E4:F4. I tried adding a Tags column to my Categories sheet but then needed to manhandle those formulas in row 4 to replicate them for my Categories sheet. Would it make sense to include the sheet name (from column D) and either assume the column name is âTagsâ or add another column to set the header name, then wrap it all in an INDIRECT() function?
Thanks for pushing at the boundaries and continuing to make the ecosystem better, @jpfieber. We are excited to offer you a $100 gift certificate as part of our 2022 Microsoft Excel Builders Challenge.