Good morning –

No amount of post searching turned up my answer, believe it or not.

I have a two-tab workbook.  Tab one serves as a Table of Contents for
different locations on Tab 2.

On Tab 1, in one cell, I want to have text, and a specific cell address of
Tab 2.

Tab 1 example of the resulting display:

Calendar 2005 -  Tab 2, D8

A couple of points.

1.  D8 will move around on Tab 2, so the Tab 1 formula will have to “track”
it.
2.  If possible, I don’t necessarily want to display Tab 2 in the result,
just the cell
    address.

I tried syntax along the lines of ="Calendar 2005 - "&ADDRESS(blah, blah),
but I just can’t make this go…

I’m stumped. Any takers?

Thanks to anyone who takes the time to respond. I’ll keep an eye on the post.

Sam