If you want to copy data from Excel to Microsoft word then follow these steps:
In Excel
Select the worksheet data (range) that you want to copy to a Word document.
On the Home tab, Clipboard group, click
All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show [...]
If you have two workbooks, or more, and you want to merge or consolidate those workbooks into one, then you may find it a tedious task to move the worksheets manually.
The following macro reads two workbooks and copy all the worksheets into a new consolidated workbook. If you have more than two workbooks as input [...]
To copy or move worksheets within the same workbook follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. The To book drop down will default to the current workbook. Leave this as [...]
To copy or move worksheets between workbooks follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. In the To book drop down select the destination workbook. You can also choose to create [...]
