Hi,
I'd like to extract data from all the text files in a folder into individual columns using VBA
lets say 2 text files in this location "C:\Users\jonny\Desktop\test\" - textfile1 contains A,B,C and textfile2 contains D,E,F (each letter is on a seperate line in their respective text file) - I'd like the output to look like this:
column A column B A D B E C E
Bookmarks