Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I avoid circular reference AND extra input | New Users to Excel | |||
input box | Excel Discussion (Misc queries) | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
input value in a cell when the previous cell is greater than 0 | New Users to Excel |