I have one main worksheet that summarizes the calculations on many other
worksheets.

I want to have a column that will Edit, Fill, Down like the following
example (z1 always stays the same no matter what the worksheet):

=a!z1
=b!z1
=c!z1

But all I get when I do an Edit, Fill, Down is:

=a!z1
=a!z2
=a!z3

I went through the reference help and 3D help, but nothing seemed to
work. If I must have a hidden column with the worksheet names, and
somehow reference the name in the formula, that is OK. I couldn't
figure that one out either.


--
langba
------------------------------------------------------------------------
langba's Profile: http://www.excelforum.com/member.php...fo&userid=4144
View this thread: http://www.excelforum.com/showthread...hreadid=474093