ExcelBanter - copy dependant validation cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy dependant validation cell (https://www.excelbanter.com/excel-discussion-misc-queries/67281-copy-dependant-validation-cell.html)

martb

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)

ewan7279

copy dependant validation cell

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)

All times are GMT +1. The time now is 07:28 PM.