I have several Word documents containing data I want to track in a spreadsheet. Each row of the spreadsheet would equal one Word document.
I’d like to have a macro that would copy the data from the Word document to Excel. Something simple would be fine, where I could position the cursor at the beginning of the Excel row, then copy data from Word (which could be in bookmarks if that’s easiest) to Excel, cell by cell, for that row.
Then the next time I have to copy data, I’d just position in the next row and run the macro again.
Can anyone help with the code for that?
Thanks…
Adri