View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default dynamic transpose

Is it possible to do a dynamic reference for a transpose?

I'd like to do the transpose of a 12 cell horizontal reference into
vertical, but I need the tranpose function to lookup the line of the 12 cells
by finding a value in a vertical list. In other words, the value that drives
it all is in a list. The 12 cells are to the right of the found cell. So
the vertical block of 12 cells (which would be the transposed values), would
have to do the following:

find the lookup value
grab the 12 horizontal cells that start about 10 cells to the right of the
found value
transpose those 12 cells into vertical.

Thx for any help.
--
Boris