Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Valadation
I am using data validation and this is working. But, now I have one more
thing to do question. I want the Phone number to pop up in another area on the form. I assume that I have to put the phone number in a separate column. Example: I have a customer number I use to match and it pulls up the 3 Ship To Address that works just fine, but after I choose the address if I want the phone number associated with the Ship To address I have chosen to show up a few lines down and not pop up the phone number for all 3 Ship To Address is that possible? Right now I use the same customer Id for all related Ship To address for this one customer. I know that if I use a different code like W224A = SHIP TO ADDRESS 1 W224B = SHIP TO ADDRESS 1 W224C = SHIP TO ADDRESS 1 This would work and pop up the phone number associated with each Ship To Address for each code but however I want the display to be W224 and not show W224A, W224B, ETC. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Valadation | Excel Worksheet Functions | |||
Data Valadation | Excel Discussion (Misc queries) | |||
Using a Hyperlink with Data Valadation | Excel Discussion (Misc queries) | |||
Data Valadation - | Excel Worksheet Functions | |||
Data Valadation help | Excel Worksheet Functions |