View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nadia.younus@googlemail.com is offline
external usenet poster
 
Posts: 23
Default 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