Hi,
I would like to reference a Named Range in one workbook that was created in a separate workbook. The reason is so that I can reference a single cell in the new workbook to a cell in the range in the Source WorkBook, and then "click and drag" so the other cells within the range populate in the new workbook as well.

Anybody's help is much appreciated. I also found that even within the same workbook, if I reference the Named Range, I will get the corresponding desired value so long as I am in the same Row as the Ranges Value that I am want.

Thank you in advance,

Michael W.