What is this function called??

Hi Everybody,

I have lots of reference material to look through, but I don't know what search-word to be using to find an answer.

I want to have a primary workspace, and then create other spreadsheets (in the same workbook) that can contain & display specfic ranges of cells from the primary spreadsheet. Naturally, any changes I make in the primary would be accuratly reflected in the "sub-spreadsheets"??

Could someone tell me what this kind of function or procedure is called, so that I can figure out how to do this?

Many thanks,
Paul

you could just use


=sheet1![cell reference] starting at the point you want to use the relevant info.


or vlookup would work.....

You would put ='primarysheet'!D279 in whatever cell you want that data to
show up. (if the name of your primary sheet was in fact primarysheet. An
easier way is to go to the cell you want the info to go into, double left
click and enter = then (without hitting enter) go to cell D279 and click on
it and then hit enter. This should put the proper cell reference in your
other cell so that whatever is in D279 will also be in the other cell and
will change as you change the contents of D279.

"jPaulB" wrote:

>
> Thanks Ben,
>
> I don't think VLOOKUP is what I need to accomplish. Pretty much what I
> want to do is -transfer- the contents of say D279 in the primary
> worksheet to any cell in another worksheet.
>
> Thanks,
>
> Paul
>
>
> --
> jPaulB
> ------------------------------------------------------------------------
> jPaulB's Profile: http://www.excelforum.com/member.php...o&userid=25195
> View this thread: http://www.excelforum.com/showthread...hreadid=568441
>
>