import tables from an Excel file, but from different sheets

		Microsoft Office Forums > Microsoft Word > Word
import tables from an Excel file, but from different sheets

FAQ

Thread Tools

Display Modes

04-20-2016, 03:25 AM

macropod

Windows 7 64bit import tables from an Excel file, but from different sheets

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Simply copy the required Excel ranges and paste them into Word using 'Paste Special' with the 'paste link' option and choose the desired paste format. Once you've done this, any changes to the Excel data should be reflected in the Word document. No macros required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help in Linking Tables in different Sheets	pemaolca	Excel	4	01-28-2015 03:12 PM
Excel Newbie Question: .dbf file import help - 1 mil+ rows	LisaExcelHelp	Excel	1	01-26-2015 07:39 AM
Adding sums from simuliar tables from different sheets.	LameDuck	Excel	0	12-04-2014 08:57 PM
Macro to import all diagrams from an excel file	kbka	Word VBA	0	04-15-2013 02:11 AM
Excel sheets	ubns	Excel	4	04-15-2012 10:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:27 PM.