How can i transpose translations from Word to Excel?
Posted on 2011-02-22
I have got a Word document which contains, amongst other things, tables which contain an english master copy and its translation in e.g. german. I then have an excel spreadsheet with those same english master copy phrases and I need to get the german translations into the Excel Spreadsheet. So something like:
Find first table in Word Document
Take first German phrase
Copy associated english translation
Go to Excel spreadsheet
Find english translation (there are multiple worksheets)
Paste German version into relevant cell
Go back to Word doc and start again.
How can I do this?