View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
martb
 
Posts: n/a
Default copy dependant validation cell

I have compiled a spreadsheet which uses the following dependant validation
formula. Is there a way to copy the validation & it's formula to all cells in
that column without incrementing the source.

E.g. replicate $A134 and A134 without next cell becoming $A135 and A135 etc


=OFFSET(INDIRECT($A134),0,0,COUNTA(INDIRECT(A134&" Col")),1)