Data validation without a static named range
Closed
CJinMadison
-
Feb 14, 2011 at 03:58 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 14, 2011 at 08:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 14, 2011 at 08:43 PM
Related:
- Data validation without a static named range
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Windows10upgrade9252.exe is not a valid win32 application - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 14, 2011 at 08:43 PM
Feb 14, 2011 at 08:43 PM
one way of doing it is
1.select column H
2.autofilter with criteria as "sahde tree"
3.copy the filtered data into another columns and name it
3.sue this named range as validation list
remember column H must have column heading
of course you can have a macro for this if you are familiar with macros
1.select column H
2.autofilter with criteria as "sahde tree"
3.copy the filtered data into another columns and name it
3.sue this named range as validation list
remember column H must have column heading
of course you can have a macro for this if you are familiar with macros