Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Autoresize a copied Excel table | Tables | |||
How do I insert Excel data as a Word table and stay within margins | Tables |