|
|
#4
05-21-2013, 04:17 AM
|
||||
|
||||
Hi Mark,
I don't use Excel much, so I can't really give a lot of help with the validation list issues. That said, I think your requirements for A7 can be met by using a separate column with just one entry per company. FWIW, I'm attaching a workbook that uses validation plus a macro to clear a dependent dropdown so that you won't get invalid results.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| Forms -with validation | ubns | Excel | 1 | 05-04-2012 08:51 AM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
| Outlook userform validation help | aiwnjoo | Outlook | 0 | 12-08-2010 12:57 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode