How to constrain input to previous entries
 

Hello every body, i am fresh in this forum so please help me out.I have
a sales report with entries that starts with customer names, data about
the specific deal and name of the sales rep.

What i need to do, is constrain each repetative customer to his
corresponding sales rep.So there must be something that I can do do the
sales rep column in my report that will make the cell prohibit the entry
of a different sales rep to a customer who was previously entered in the
report in correspondance to a different sales rep ( you can tell some
foul-play is happening in my company ;) ).

thanx


--
SMUDGER
------------------------------------------------------------------------
SMUDGER's Profile: http://www.excelforum.com/member.php...o&userid=30670
View this thread: http://www.excelforum.com/showthread...hreadid=503289

How to constrain input to previous entries
 

Use a VLOOKUP formula in the cell, and lock the cell to prevent over-writing it.

The formula would be along the lines of:

=VLOOKUP(Cell with customer Name,Range with old data, Column number within range of sales rep data,
False)
like, this in cell B100:
=VLOOKUP(A100,$A$1:A99,2,False)
with customer names in column A, reps in column B.

HTH,
Bernie
MS Excel MVP


"SMUDGER" wrote in message
...

Hello every body, i am fresh in this forum so please help me out.I have
a sales report with entries that starts with customer names, data about
the specific deal and name of the sales rep.

What i need to do, is constrain each repetative customer to his
corresponding sales rep.So there must be something that I can do do the
sales rep column in my report that will make the cell prohibit the entry
of a different sales rep to a customer who was previously entered in the
report in correspondance to a different sales rep ( you can tell some
foul-play is happening in my company ;) ).

thanx


--
SMUDGER
------------------------------------------------------------------------
SMUDGER's Profile: http://www.excelforum.com/member.php...o&userid=30670
View this thread: http://www.excelforum.com/showthread...hreadid=503289