Import data from Excel into Word document fomat
 

I use a Excel spreadsheet that calculates alot of financial information on
individual sheets, then merges the info into 'Report' format (on another
'sheet' within the same spreadsheet). How do i transfer the 'Reports' into a
Word Document?
Thanks
--
Angela

Import data from Excel into Word document fomat
 

From Word click on Insert in the menu and select Object. Click the From File
tab, locate your Excel file and click the Link to File check box if you wish
to have an updateable link in the document. Once it's linked you can double
click on the Excel object to open Excel from inside the Word document.

Or you can copy your report and paste into a Word document. It will come in
as a table.
--
Kevin Backmann


"Angela" wrote:

I use a Excel spreadsheet that calculates alot of financial information on
individual sheets, then merges the info into 'Report' format (on another
'sheet' within the same spreadsheet). How do i transfer the 'Reports' into a
Word Document?
Thanks
--
Angela

Import data from Excel into Word document fomat
 

Thank you for your reply. I have tried what you suggested but only one page
is comin gover to word and it has the excel boxes showing. (Sorry I am not
very computer literate). I need to get the reports (located on three
different tabs) from my excel sheet over into a Word document format.

--
Angela


"Kevin B" wrote:

From Word click on Insert in the menu and select Object. Click the From File
tab, locate your Excel file and click the Link to File check box if you wish
to have an updateable link in the document. Once it's linked you can double
click on the Excel object to open Excel from inside the Word document.

Or you can copy your report and paste into a Word document. It will come in
as a table.
--
Kevin Backmann


"Angela" wrote:

I use a Excel spreadsheet that calculates alot of financial information on
individual sheets, then merges the info into 'Report' format (on another
'sheet' within the same spreadsheet). How do i transfer the 'Reports' into a
Word Document?
Thanks
--
Angela

Import data from Excel into Word document fomat
 

You can remove the cells from word under tableconvertconvert table to text
or paste special as unformatted text
If you have data in multiple sheets in Excel then you need to copy multiple
times or use code that will do this for you. So first copy and paste the
first sheet, then the second and so on.



--


Regards,


Peo Sjoblom




"Angela" wrote in message
...
Thank you for your reply. I have tried what you suggested but only one
page
is comin gover to word and it has the excel boxes showing. (Sorry I am not
very computer literate). I need to get the reports (located on three
different tabs) from my excel sheet over into a Word document format.

--
Angela


"Kevin B" wrote:

From Word click on Insert in the menu and select Object. Click the From
File
tab, locate your Excel file and click the Link to File check box if you
wish
to have an updateable link in the document. Once it's linked you can
double
click on the Excel object to open Excel from inside the Word document.

Or you can copy your report and paste into a Word document. It will come
in
as a table.
--
Kevin Backmann


"Angela" wrote:

I use a Excel spreadsheet that calculates alot of financial information
on
individual sheets, then merges the info into 'Report' format (on
another
'sheet' within the same spreadsheet). How do i transfer the 'Reports'
into a
Word Document?
Thanks
--
Angela