Hi everyone,
I have several of text files having the same pattern and header. I need to extract just one column from text file and paste it to excel. What now I am doing I open the text file in a workbook, separate the columns,copy the specific column and past it to the another excel sheet. What I need to do:
1. Open text file
2. copy one column from the text file
3. paste to excel sheet
4. automate this steps for a folder of text files
I am really new in excel VBA coding and could not find a way to do this. Please help me.
I have several of text files having the same pattern and header. I need to extract just one column from text file and paste it to excel. What now I am doing I open the text file in a workbook, separate the columns,copy the specific column and past it to the another excel sheet. What I need to do:
1. Open text file
2. copy one column from the text file
3. paste to excel sheet
4. automate this steps for a folder of text files
I am really new in excel VBA coding and could not find a way to do this. Please help me.