Using Offset on two seperate worksheet

[nadia.younus]

Hi,

I have two worksheets:

1) A worksheet where data is displayed
2) A worksheet with the raw data

I need to know, can an offset formula in an Excel formula bar of
worksheet 1, be clever to pick data from selected cells in worksheet 2
and display it in the first worksheet?

Any help would be much appreciated.

Nadia

 

[Robert Hind]

Nadia,
Yes. There are many ways in which the raw data from a selected cell can be
displayed in another sheet.

For example =index([range/named range],[row number], [column number])

= indirect(F9) ....where cell F9 contains the Name (Named Range) of the cell
containing the raw data value.

and many other ways

almost the sky is the limit.

Cheers
Robert Hind
(e-mail address removed)