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