Thread: Writing Financial Reports in MS Word
View Single Post
 
Old 12-07-2021, 03:25 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
If I understand the requirement correctly, copy the Excel cell or range to the clipboard, then in Word right click and paste a link. The Excel information is pasted into the document. Provided both the worksheet and the document are open, the document will display any change to the Excel data in real time. If the worksheet is not open, then you would have to update the link - either at the prompt when you open the document, or manually (CTRL + A then F9)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote