M
martb
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)
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)