View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Difficulty in transposing

"SteveW" wrote:
That'll work if $$ format used in cell formula

But we won't get it (ie a simple link formula) to fill across / down and
remain linked "transpose-wise" unless you subsequently edit each cell's
formula manually, or unless we use formulas such as those illustrated in my
response (the illustration's just one way, of course). Think ease of formula
propagation could be the crux issue here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---