View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 99
Default get data from a cell in each named range

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