Macro: Exporting Data to a LEGIBLE Excel Spreadsheet

[jeffcoleky]

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

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

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

If someone can help me figure out how to get this done in such a wa
that I can automate, I would be very grateful. Your help for this wil
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 i
manually (aside from copy and paste) would be super.

Thanks so much!! -Jef

+-------------------------------------------------------------------
|Filename: 04172012 Results Copied.zip
|Download: http://www.wordbanter.com/attachment.php?attachmentid=127
|Filename: 04172012 Results.zip
|Download: http://www.wordbanter.com/attachment.php?attachmentid=128
+-------------------------------------------------------------------

 

[jeffcoleky]

Nevermind, got it resolved by someone else

+-------------------------------------------------------------------
+-------------------------------------------------------------------