Ron,

Many thanks again for the assistance. It works to perfection!! Now I can
link the other workbooks as well. Couldn't have done it without your precious
help.

"Ron de Bruin" wrote:

Hi pfa

Firts we change the search column from A to D


With DestWks.Range("A:A")

Change to

With DestWks.Range("D:D")


And the we change the offset from 1 to 11
Column O is 11 columns to the right from column D (your seach column)


Rng.Offset(0, 1).Formula = _
"=" & PathStr & Range("A50").Address

To

Rng.Offset(0, 11).Formula = _
"=" & PathStr & Range("A50").Address


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pfa" wrote in message ...

Ron,

Seems to do exactly what I requested. However, I neglected to tell you the
reference numbers in Summary Master are in Column D, and the results for DPP
Q2 should appear in Column O. If you let me know what changes in the code are
necessary to get this result, I can then use the same code for all the other
workbooks that I need to drop the same type information into the Summary
Master.

Again, many thanks for your patience and help.