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


--
jPaulB
------------------------------------------------------------------------
jPaulB's Profile: http://www.excelforum.com/member.php...o&userid=25195
View this thread: http://www.excelforum.com/showthread...hreadid=568441

you could just use


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


or vlookup would work.....


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568441

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

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