Hello,

I am a first time poster, please excuse me if I posted in the wrong sub section.



I am trying to create a word document for work that will improve the efficiency of a certain task. Here is what I would like to do.

• I need word to pull data from excel and insert it to.. let's call it "LINE 1" of word. This part I have done already. It looks like this:

{ LINK Excel.Sheet.8 "C:\\Documents and Settings\\*FAKE FOLDER\\FAKEFILE.xlsx" "Sheet1!R2C1:R2C3" \a \f 4 \r \* MERGEFORMAT }

[Note: This part works. Now comes the part I do NOT know.]

• I need a link that links a cell from excel to "LINE 2" of word ONLY IF the previous link on "LINE 1" has data that exists in excel.

How do you do a conditional link like that?

Please help and I appreciate the one's who do!

-Pete