If it is so large (how large?) then it might be worth
it to move it to a real database, so you can use SQL to
query and update the data. It will take some time to move
over, but it probably will pay off in the long run.

RBS


"TIMOTHY" wrote in message
...
Dear All

I've a vast database of movies & Musics titles and i want to update the
price

i have to find each text in database and stocklist since i cant vlookup it
because same title can be manufactured by many other also

is there a way to find text automatically using VBA?