|
|
|
|
#1
03-09-2016, 08:19 AM
|
|||
|
|||
You are so right, much more clearer formula. Ive opened the file and if you now look on the drop down box in cell A13, its gone from looking at the rate card to now looking at the forecast tab.
From now on I'm naming all code areas so thanks for the lesson 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Trying to get Data into Validation List according to Client Name and Document Type
|
Maoz | Excel | 5 | 01-24-2016 01:17 AM |
|
Data Validation List based on Two Named Ranges
|
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
|
Data validation list filter with range defined by OFFSET
|
Mango123 | Excel | 4 | 03-18-2014 02:52 PM |
| How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |
|
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Windows 8 
Office 2007
Hybrid Mode