Macro: Exporting Data to a LEGIBLE Excel Spreadsheet
** 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
|