View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default


"Domenic" wrote in message
...
Try...

A8, copied down:

=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))


Clever!