Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 08-01-2016, 12:28 PM
gebobs gebobs is offline Alternative to a data validation list? Windows 7 64bit Alternative to a data validation list? Office 2010 64bit
Expert
Alternative to a data validation list?
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Another nice feature of your solution is I don't need the first letter of the SKU to agree with the vendor name. In fact, one vendor was just acquired by another company, now their codes and name do NOT agree, and we have no intention of changing the SKUs. This solution circumvents that mess as well as the possibility that we might have two vendors with the same first letter in the future.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternative to a data validation list? Data Validation - List Webbn111 Excel 9 03-09-2016 04:30 PM
Alternative to a data validation list? Trying to get Data into Validation List according to Client Name and Document Type Maoz Excel 5 01-24-2016 01:17 AM
Alternative to a data validation list? Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM
Alternative to a data validation list? Data validation list filter with range defined by OFFSET Mango123 Excel 4 03-18-2014 02:52 PM
Alternative to a data validation list? Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft