I have items B2 through Q2 and B17 through Q17 on six sheets. I want to
create references on a new sheet with these two sets of rows listed as
two columns, A1 through A96 and B1 through B96. Is there a way to set
this up so I only have to enter a few forumulas and then fill down?

Usually when you fill down, it changes the row, and when you fill
accross, it changes the column. Is there a way to temporarily flip this
so I don't have to manually enter all 96 references?


--
bob135
------------------------------------------------------------------------
bob135's Profile: http://www.excelforum.com/member.php...o&userid=33388
View this thread: http://www.excelforum.com/showthread...hreadid=532136