View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
benjampm benjampm is offline
external usenet poster
 
Posts: 1
Default Change row and column when copying formula

I want to fill down a formula where the row and column both incriment by one:

=CONCATENATE(FK6,G6,GQ6)
=CONCATENATE(FL7,H7,GR7)

How can I do this?