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?