Quote:
Originally Posted by p45cal
In the attached, is data validation in column B which refers to a dynamic named range called drpdwn2 as the list.
The formula was added to the named ranges while the active cell was in row 3:
Code:
=OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0,,COUNTA(OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0)))
It is dynamic both in width and vertical position. |
I really like this approach simply because I am familiar with it! The question that I would like to ask is, can this approach draw values from another worksheet within the workbook? This would keep the front page "clean", as in no other tabular data being seen.
04-12-2018, 07:42 AM
Similar Threads
How to import list from Excel into drop-down list into word
Windows 7 32bit 
Office 2003
Threaded Mode