Hi guys,

Would anyone be able to give a little advise?

I am trying to make a database in Excel, due to License restrictions (and
cost), Excel is the only program we have a site license for.

The database needs to be able to hold regions of data, which will show
contact details for each region. In each region it would show around 20
Technicians, 2 Supervisors, 1 Manager, a Field manager, and finally the Head
of Department. I would also like to make it possible that they just enter
the Region Code or Tech ID and it bring up the region they work in.

I know it sounds like a tall order but if someone could give me some advise
as to which functions would be the best to use that would be a great help.
Or if you already have something like this give me a head start. But please
do not pass any actual data. I do not want people getting into trouble (Data
Protection Act).

I am also trying to learn more about Excel so I can eventually be able to
create something more complicated easily.

Kindest regards,

Andy Mc