Thread: Fill Down In Rows But Want to Increase By Letter
View Single Post
  #4   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
"pinmaster" wrote:
=INDIRECT(CHAR(66+ROW(A1))&4)

This would work but only till col Z. Perhaps one way to skirt the col letter
incrementing problem (Z, AA, ... IV) is to use INDEX, eg:
=INDEX(Sheet1!$C$4:$IV$4,,ROW(A1))
which allows a straight copy down to transpose the source sheet's cols C to
IV
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote