I made this work but I may not be able to tell you how to do it. I used the
PASTE SPECIAL and TRANSPOSE but used it on the formula. So I created the
formulas up and down instead of side to side like you're doing and I put a $
in front of the column letter and once the formulas were filled in going down
I copied and did a PASTE SPECIAL and TRANSPOSE on the formulas and it worked
slicker than snot.







"Kaziglu Bey" wrote:


Appreciate your efforts anyways.:)

Scott Wrote:
I see what you're trying to do and now I know why you want to do it but
for
the life of me I dont have a solution right now. My only suggestion is
to
copy the section you want out of the Serial Page and do a PASTE SPECIAL
then
choose TRANSPOSE and this will put the data in the format you want,
however,
it wont update automattically because it is just a copy of the data and
not a
formula. Sorry, hope someone else can help.


--
Kaziglu Bey
------------------------------------------------------------------------
Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086
View this thread: http://www.excelforum.com/showthread...hreadid=558691