Oh dear. The references don't update when you drag down the way they do with
normal cell references. Any ideas?!?

Thank you

"Arvi Laanemets" wrote:

Hi again

I missed that all source ranges are in external workbooks - I didn't check
this out, but probably you can't refer to ranges in closed external
workbooks, and I'm not sure that INDEX works with them as source too.

Easiest will be to have a hidden sheet in every of source workbooks, where
the value from range is calculated in certain cell, using p.e. formula from
my previous posting. Then you can use simply link formulas to get those
values into your summary workbook.


Arvi Laanemets


"Arvi Laanemets" wrote in message
...
Hi

=INDEX(RangeName,3,4)


Arvi Laanemets



"Shazzer" wrote in message
...
I have several named ranges, all the same shape and size.

In another workbook I want to pull through the data from the cell on the
3rd
row, 4th column of each named range.

I don't want to refer to the absolute cell reference as they might get
moved
about.

Is this something that can be done easily?

Thank you