hello there
I have an Excel sheet and Word Document open at the same time.
I need to export certain data from the excel sheet to a certain "cell" on a table found in Word.
The excel is opened originally from Word (I have a macro/button which does that).
I select certain data from Excel, then I would like to 'press' a CELL in Excel (using Worksheet_SelectionChange) and this will cause a number of cells data in Excel to be moved to a certain row in a table on Word.
Any ideas how to do the actual transfer from one to the other with VBA ????
Thanks in advance
Any ideas
I have an Excel sheet and Word Document open at the same time.
I need to export certain data from the excel sheet to a certain "cell" on a table found in Word.
The excel is opened originally from Word (I have a macro/button which does that).
I select certain data from Excel, then I would like to 'press' a CELL in Excel (using Worksheet_SelectionChange) and this will cause a number of cells data in Excel to be moved to a certain row in a table on Word.
Any ideas how to do the actual transfer from one to the other with VBA ????
Thanks in advance
Any ideas