Using Offset on two seperate worksheet
 

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

Using Offset on two seperate worksheet
 

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



wrote in message
...
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