Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
trchbrr
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

I have a recurring report that I am consistently going from Excel to Word and
pasting the information from a cell in Excel to a Table Cell in Word. Is
there a way of performing this routine in an automated fashion?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Kevin B
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

Why don't you do an INSERT, FILE and insert the Excel file as a link. Any
time the data changes in Excel the Word document will reflect that change.
--
Kevin Backmann


"trchbrr" wrote:

I have a recurring report that I am consistently going from Excel to Word and
pasting the information from a cell in Excel to a Table Cell in Word. Is
there a way of performing this routine in an automated fashion?

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
trchbrr
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

The intent of my exercise is to be able to have a series of cells within
Excel populated and then to have that information extracted and placed into a
report. No need to have the file imported, just data within the range of
cells.

Thank you for your suggestion and would hope that my reply is clear and
concise enoguh to produce a solution.

- trchbrr

"Kevin B" wrote:

Why don't you do an INSERT, FILE and insert the Excel file as a link. Any
time the data changes in Excel the Word document will reflect that change.
--
Kevin Backmann


"trchbrr" wrote:

I have a recurring report that I am consistently going from Excel to Word and
pasting the information from a cell in Excel to a Table Cell in Word. Is
there a way of performing this routine in an automated fashion?

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Ed
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

Is all the information in Excel in the same workbook, same worksheet, same
row or column with no blank cells? Or is it scattered and must be collected
piece by piece? Is it all going into the same Word table in a continuous
row or column of cells? How many instances are you talking about?

Ed

"trchbrr" wrote in message
...
I have a recurring report that I am consistently going from Excel to Word
and
pasting the information from a cell in Excel to a Table Cell in Word. Is
there a way of performing this routine in an automated fashion?



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
trchbrr
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

Hi Ed -
The information is on the same worksheet within one workbook.
The cells are not contiguous, rather the information is dispersed
and entered after a question is asked. This is information is broken
down like this:

Topic 1
Sub - Topic 1
Question n Answer n
Question n+1 Answer n+1
....
....
....
Sub Topic 2
Question n Answer n
Question n+1 Answer n+1
....
....
....
Topic 2
Sub - Topic 1
Question n Answer n
Question n+1 Answer n+1
....
....
....
Sub Topic 2
Question n Answer n
Question n+1 Answer n+1
....
....
....

and so forth, for about 200 questions within this question set.

As indicated the only information needed is the answer n, n+1, and so on.

Thank you for your question and support in resolving this issue.

-trchbrr

"Ed" wrote:

Is all the information in Excel in the same workbook, same worksheet, same
row or column with no blank cells? Or is it scattered and must be collected
piece by piece? Is it all going into the same Word table in a continuous
row or column of cells? How many instances are you talking about?

Ed

"trchbrr" wrote in message
...
I have a recurring report that I am consistently going from Excel to Word
and
pasting the information from a cell in Excel to a Table Cell in Word. Is
there a way of performing this routine in an automated fashion?






  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Ed
 
Posts: n/a
Default How do I get Excel information inserted into Word Table cell?

From what you have described, your questions are in one column (such as A5)
and the answers you want to extract are in the next column over (such as
B5). If it's that orderly, my next question is whether there is something
unique in every and ONLY in every question or answer cell. For instance,
does each and only each question cell have "Question:" or something similar?
Or each and only each answer cell have "Answer:" or something similar?

If so, then it is possible to do a search on that term and pick up the
values you want from each matching cell. These can be written into an
array, then the macro can open your Word report blank and write the values
from the array.

It may also be possible to sort the Excel sheet to show only the cells with
your answers, select those cells, and paste them into Word as a Word table,
or even just down one column of an existing Word table.

Ed

"trchbrr" wrote in message
news
Hi Ed -
The information is on the same worksheet within one workbook.
The cells are not contiguous, rather the information is dispersed
and entered after a question is asked. This is information is broken
down like this:

Topic 1
Sub - Topic 1
Question n Answer n
Question n+1 Answer n+1
...
...
...
Sub Topic 2
Question n Answer n
Question n+1 Answer n+1
...
...
...
Topic 2
Sub - Topic 1
Question n Answer n
Question n+1 Answer n+1
...
...
...
Sub Topic 2
Question n Answer n
Question n+1 Answer n+1
...
...
...

and so forth, for about 200 questions within this question set.

As indicated the only information needed is the answer n, n+1, and so on.

Thank you for your question and support in resolving this issue.

-trchbrr

"Ed" wrote:

Is all the information in Excel in the same workbook, same worksheet,
same
row or column with no blank cells? Or is it scattered and must be
collected
piece by piece? Is it all going into the same Word table in a continuous
row or column of cells? How many instances are you talking about?

Ed

"trchbrr" wrote in message
...
I have a recurring report that I am consistently going from Excel to
Word
and
pasting the information from a cell in Excel to a Table Cell in Word.
Is
there a way of performing this routine in an automated fashion?






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Autoresize a copied Excel table lincoln Tables 1 April 7th 06 09:17 AM
How do I insert Excel data as a Word table and stay within margins Fritz Tables 1 February 6th 05 08:39 AM


All times are GMT +1. The time now is 06:09 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"