AVAIL_FolderTags Split "Folder path" into Tags - some exclusion frameworks - rough VBA ©Ron Allen all rights reserved
Attribute VB_Name = "AVAIL_FolderTags" Option Explicit Option Compare Text Const vbqt = """" ''quote quick reference in string ''GENERATE FOLDER TAGS FOR AVAIL EXPORTS ''get 1st worksheet ''get (only) first list object Sub Add_FolderTags_To_Table () ''run on open or add to XLSM Dim ws As Worksheet ''Active worksheet Dim LI As ListObject ''List object AKA Table Dim lc As ListColumn ''List Column reference for formulas Dim found As Boolean ''boolean for search Dim c As Range ''Column Dim r As Range ''Row Set ws = ActiveWorkbook.ActiveSheet ''Active workbook Set LI = ws.ListObjects ( 1 ) ''ONE table per sheet with TSV ''Che...