I am looking for someone revise an Excel spreadsheet that has VBA macros.
The sheet uses a macro to select a txt file then it reads the txt file and pastes some of the data into excel (columns K & L). This is on the "Current" tab of the attached .xls file.
Ideally, I would like to select two different txt files and compare the data in adjacent columns. An example of what I was thinking is in tab "Ideal"
As you will see, columns K-O were copied into columns P-T; they are labeled "Plan A" and "Plan B." The Macro buttons will need to be renamed. Also, after selecting the file, the macro writes the cell location on to cells S11-S13, this cell location might need changing.
Also attached is the data .txt file.