Extract data from txt to excel

[romeokk34]

Sample data in text file

Module 6
Pressure angle 22
Helix angle 25




Step 1: program ask to open a txt file
Step 2: program seprate data into row and column
Step 3 : program search for names in txt file which are given in cells (A1:A10) in sheet1 in current worksheet
Step 4: copy data from column b in txt and paste it in column b of sheet1 of current worksheet for respective names