View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Barry Lennox[_2_] Barry Lennox[_2_] is offline
external usenet poster
 
Posts: 29
Default Transpose problem

Many thanks. It works well

Barry

"Pecoflyer" wrote:


In C4 enter
Code:
--------------------
=indirect("mastersheet!a"&column())
--------------------
and drag to the right


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47395