I have some code I am trying to use to copy specific columns from one worksheet to another worksheet in the same workbook. I need help to determine why it doesn't work.
When code runs it takes you to directory to pick file, deletes some extraneous records than concatenates the record number with the seq num. Then I want to take specific columns and copy to new worksheet. This is where it bombs.
I have attached the code I'm using and data file.