Hi all,

Can anybody help me please?

I am trying to build a spreadsheet that has a list of customers on on
sheet (that I control) and some other data on another that a user ha
to fill out.

The reason I want this is that all my users are updating data wit
different spellings of customers (eg Sainsbury / Sainsbury's) an
obviously then does not give accurate reporting.

What I want the user to do is to update new lines with data, but onl
be allowed to select the customers from my sheet (like a drop down lis
or combo box). I obviously don't want a combo box on each cell (it ha
3000 lines of data), but does anyone have any ideas on how I coul
force them to only pick my controlled list???

This could be through protection / macro / vb???

Anything anyone could suggest would be a great help....

Many thanks
Mark
:) :

--
certain_deat
-----------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...fo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=55138