Data validation of unique entries using VB

S

Sinner

I am using the below formula to create a validation list with unique
entries.

=IF(COUNTIF(O$7:O89,O89)=1,MAX(N$7:N88)+1,"")
-
-
-
-
Drag down

ABC is defined name for the list to be used for validation
=OFFSET(Data!$Q$8,0,0,MAX(Data!$N:$N),1)


I would like to have VB solution as I'm having lot of sheets.
Object is to take calculations to back end in order to save
calculation time & space.
 

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

Top