Last line of multiple text files matching first column numbers only

Hi,
I have a folder with multiple logon details for my company network. This is generated by a script at logon. Every time the script runs it creates a new line so I would need the last line of the text file.
It looks like this,

tuttd logged onto HCRPC23138, IP address 10.201. 33. 24 at 14:47:20 on 2012/06/28

The first characters are the username, the test file is also called HCRPC23138. The spread sheet contains the name (HCRPC23138) in the first column. What I would like to do is get the test file based on the name in A:1 and the put the username in the next column. I am not very good at VBA. Well to put it plainly I suck at it. I have created powershell scripts to do the work however it is still quite a manual process copying and pasting the values from CSV’s

I have checked Import Specific line from multiple text files however it doesn’t quite work. As it puts all the text file information in the spread sheet.

Thanks,

Thanks tigeravatar. You're a legend, man, you're a genius in my books!

I've changed the code a tiny bit to suit my purposes. I've attached the code and will set the thread to solved.

Please Login or Register  to view this content.

Thanks again.

Christiaan