Fix A134 by using the " $ " sign i.e. $A$134 in both occurrences in the formula

"martb" wrote:

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)