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.

Hi
Solution to what?
Paul

On Feb 20, 10:44*am, Sinner <ims...@gmail.com> wrote:
> 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.

Hi Paul,

All these formulas doing calculation in code rather than in cell.


On Feb 20, 4:29*pm, paul.robin...@it-tallaght.ie wrote:
> Hi
> Solution to what?
> Paul
>
> On Feb 20, 10:44*am, Sinner <ims...@gmail.com> wrote:
>
>
>
> > 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.- Hide quoted text -
>
> - Show quoted text -