View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dj_money dj_money is offline
external usenet poster
 
Posts: 1
Default Transposing Cells


I got Two workbooks I'm working with. One is _Destination_ and the
other will be the _Source_ Workbook.

In the _Source_Workbook_, this is what I have:

.... A .. B
1: Ran 30
2: Ran 20
3: Ran 10

I want to link this source workbook to my
_Destination_Workbook_ so that it would display
this:

..... A . B . C.. D
1: RAN 30 20 10

Anyone knows the function for this? I'm not sure if it's transpose(),
Index(), column().... I don't know. I tried it all and I it won't run
the way i want it. Please Help...


--
dj_money
------------------------------------------------------------------------
dj_money's Profile: http://www.excelforum.com/member.php...o&userid=37409
View this thread: http://www.excelforum.com/showthread...hreadid=570962