I've got database over 30.000 codes (rows).
When I make formula like "=VLOOKUP(B5;'C:\Documents and Settings\Dejan\Desktop\[Ponude.xls]Šifre'!$A$2:$L$32199;5)" it works, but
I need VBA code to make the same thing like formula does.
Something like in access and visual basic.
thank you
Best wishes
When I make formula like "=VLOOKUP(B5;'C:\Documents and Settings\Dejan\Desktop\[Ponude.xls]Šifre'!$A$2:$L$32199;5)" it works, but

Something like in access and visual basic.
thank you
Best wishes