LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Valadation Jeff Excel Worksheet Functions 4 December 15th 08 07:32 PM
Data Valadation claude jerry Excel Discussion (Misc queries) 5 April 14th 07 04:04 PM
Using a Hyperlink with Data Valadation Scott@CW Excel Discussion (Misc queries) 0 November 30th 06 04:07 PM
Data Valadation - KimberlyC Excel Worksheet Functions 1 June 2nd 05 09:29 PM
Data Valadation help KimberlyC Excel Worksheet Functions 2 April 18th 05 01:24 AM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"