Getting data from a notepad file

okay I have 2 attachments one is the excel file and the other is the text file... so what I want is when the form comes up and and asks for the part number I want it to look for the matching file and take the most recent data ( which is always at the bottom of the text file) and in the excel sheet I put in red how I want the data to come over so looking at the data you can see which values I want to come over I just put a couple in there so you had and idea but id like all 15 to come over.


when each number is found it copys that number and the first number after the word DATA in each line for example ... using the data above the most recent set of data is at the bottom and number "1" is found in one of the rows and the first number after data is ".388 D" then number "2" is found and the first number after "DATA" is ".441 D" and so on...