Hi Ken -

In rereading my posting, I'm not sure if its a relative or absolute
reference I want any more, but it is definitely always the second tab ;-)

The summary sheet at the first tab references only into the second tab,
and no further.

....best, Hash

In article ,
"Ken Wright" wrote:

No but there are other ways to handle these kinds of issues. Give us some
more detail of your layout. At the moment I am picturing some kind of
summary sheet at the start, that I am unsure of as to whether it references
just your second tab, or all the tabs, or whether it is a mixture.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

wrote in message
...
Gang -

I have a workbook with a summary worksheet at the first tab, and then a
new worksheet inserted every quarter as the second tab. Earlier quarters
are pushed to the right on the tabs.

Is there a way to reference data on the second tab no matter what that
second worksheet is titled? It changes every quarter. Right now I do a
global replace manually via menu.


Thanks in advance.

...best, Hash