I tried the first answer I recieved and it worked. I will try yours later.
Thanks for the reply. Sorry about the late response.
Ed

"Bernie Deitrick" wrote:

Ed,

Try:

=INDIRECT("'"& $A$3 & "'!" & ADDRESS(ROW(C3),3))

HTH,
Bernie
MS Excel MVP


"milkman" wrote in message
...
When I try to fill series with the following: =INDIRECT("'"$A3$"'!C3") The
absolute ref advances by 1 step ( I want it to stay the same throughout) and
the C3 ref does not change at all. But it is the C3 ref that must change.
Thanks!
Ed