Thanks for the accept.
Yes you can export Excel data into Word, but when the excel sheet format is as complex as the one you have, the exported data will be very hard to work with in Word.
Here are a few ways you can export Excel data to Word.
- Select and copy the entire data or part of the data from Excel, then go to Word and apply the regular Paste command.
- Select and copy the entire data or part of the data from Excel, then go to Word and apply the Paste Special command. Then you can choose Unformatted Text , RTF, or HTML format
- From Word, click Insert > Object > Create from File tab, then select your file.
Try experimenting with these options. I would suggest you start with the Insert > Object option first as this will create tables that include all your data and maintains the table order. If you want to make sure all the text in the cell gets copied (but without any table formatting) choose the Paste Special > Unformatted Text option.
But as I said it is much more difficult to work with tables in Word than it is in Excel.
Hope this helps. Let me know if you have any questions.