Sheet to Word doc

[mikecox39]

How do I get a worksheet from an XL workbook, into a Word Doc named "Financial Report, so that it is always current?

 

[sadboy309]

MS Word:
Menu Chèn> Đối tượng> Loại đối tượng: Bảng tính Microsoft Excel> OK. Or Tab Create from File > Browse... > Choose file > Ok.

 

[mikecox39]

MS Word:
Menu Chèn> Đối tượng> Loại đối tượng: Bảng tính Microsoft Excel> OK. Or Tab Create from File > Browse... > Choose file > Ok.

Hmmm, thanks for responding but I only speak English, can you translate this?

 

[Macropod]

Copy the Excel range then, in Word, use Paste Special with the 'paste link' option and your preferred display format.

 

[mikecox39]

Copy the Excel range then, in Word, use Paste Special with the 'paste link' option and your preferred display format.

Thanks, but isn't that just a static copy of the page, is there a way to link the page so that the page in the Word document is always current, so it doesn't have to be copied whenever it gets changed?

 

[Macropod]

Instead of doubting, you might at least try it...

 

[mikecox39]

Apologies Your right, I should have tried it first.

Thank-you, it's exactly what I was looking for. ray: