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

Absolutely brilliant!! This will save me so much time. Thank you v much
indeed

"Arvi Laanemets" wrote:

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