Hi,

I have a database which contains Customer Code, Customer Name, Order
Manager, Customer Region.
I am creating a template in which after entering the Customer Code;

Customer Name, Order Manager, Customer Region.

gets displayed automatically using Vlookup.
But Order Manager is getting updated regularly & customer code is been added
& deleted regularly.

I need another method that is linking database (Excel) using query within
Excel? so that as excel database gets updated everything gets updated in my
new template .