copy dependant validation cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Two Formulas to One 1
Data Validation - dependant Lists 1
How to fix Compatibility error 3
alter code to apply to range (links cells w/ row insertions) 1
Data Validation List will not Fill Down 3
Trailing 30 days sum calculation with excel 1
Data Validation-Dependent Lists 2
stumped on creating dependent data validation lists 1

Back
Top