C
certain_death
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
:
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
![Smile :) :)](/styles/default/custom/smilies/smile.gif)