Is there way to pull in a txt file "11-20-18-loan-plug-sql.txt" into my "Plugs" worksheet tab "Txt File" ?
I then need to match the data in the "Txt File" tab that has been pulled in to correspond to the "Plug tab in Column L marked in Blue. (Columns A;A,B:B,C:C,D:D,E:E,F:F,G:G,H:H) will need to correspond to the data in the "Txt File" tab and provide a choice of (Match, Change, No match) - These are all highlighted in yellow in A2:H2 that need to match the TXT. Notice that The TXT file will have a different name for Columns (E:H) and those names I've provided in (E1:H1)
P.S. You are the best!