** Warning: I am a Newbie without programming experience **

I am regularly sent documents like the word document attached: "04172012 Results.docx". My job is to copy and paste each line in the word doc into the attached excel spreadsheet: "04172012 Results Copied.xlsx"



However, i KNOW there's a better way than this. I've tried to search/replace the spaces with various characters, then saving it as a text doc, and lastly then importing it into excel, but I just can't get the right combination of characters to make it work.

If someone can help me figure out how to get this done in such a way that I can automate, I would be very grateful. Your help for this will save me 30-60 minutes every time i have to do it.

I would prefer some sort of macro but being told the steps to do it manually (aside from copy and paste) would be super.

Thanks so much!! -Jeff

Attached Files

	04172012 Results Copied.xlsx (92.3 KB, 19 views)
	04172012 Results.docx (37.2 KB, 20 views)