I don't know really anything about programming macros, but I am hoping that those who do on here can tell me if this is possible, and maybe how to do it.

I have a word document full of various tables, all formatted the same. A single row in one of these tables is 3 columns wide. I have made an example of three tables below.



This is what I want to happen: As you can see in my example, the Summary Table is populated with entries from Table 1 and Table 2 only when the second cell in said tables has an entry. In situations where the first cell has an entry (like Table 1, O1 being the first cell entry) the Summary table does not draw this information down to itself and autofill it in.

Long story short, I am trying to create an automatically filled summary table that autofills with data entered into the other tables in my document. The summary table will know what info to put in itself because I only want it to autofill entries into itself that have a second column entry. If its a first column entry, it does not need to go into the summary table.

Table 1

O1 W
O2 X

Table 2

O3 Y
04 Z

Summary Table

O2 X
O3 Y

Attached Images

Table Problem.jpg (63.7 KB, 17 views)

The creation of your summary table could indeed be automated with a macro, but we'd need to see a document with some representative data (delete anything sensitive) and a clear indication of where the summary table is to appear before it could be coded. You could attach such a document to a post via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

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