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