View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Fill Down In Rows But Want to Increase By Letter

Sounds like you want a dynamic transpose to Sheet1's C4:IV4 ..

In Sheet2,

Put in the starting cell, ie in C3:
=INDEX(Sheet1!$C$4:$IV$4,,ROW(A1))

Copy C3 down as far as required
(maximum copy down is to C256)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karl" wrote:
Hi I want to fill down by rows say c3,c4,c5 so on but want it to fill by
letter. Example I want c3 to be c4 c4 to be d4 c5 to be e4 with the 4
staying constant but go up by letter going down a row. Hope this makes sense.
The c4,d4,e4,are results from another sheet. Thanks Karl