Hi Prashant, For Validation, you have to choose both of the items i.e. Base Data and it's validation, in order to change both the values. i.e. you have choosen Product 1 and then Specification 6. Now, if you have choosedn Product 2, the next item (Specification 6) will not change automatically unless you go and click on drop -down.
I have added one more formula in green in the right side of those two yellow cells. Just check if you are getting the logic. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar <prashant...@gmail.com>wrote: > Hi All > > here my doubt is > The Validation is not having constraint, > i.e. afte entering one product and specification, if i am again changing > the product.the specifition remain same? > > Eg. > Product 2 Specification 6 > > how can we resolve this ? > > Regards. > Prashant. > On Wed, Apr 8, 2009 at 11:33 PM, Harmeet Singh <harmeet.hew...@gmail.com > > wrote: > >> Plz find attached file. >> >> >> >> >> On Wed, Apr 8, 2009 at 4:10 PM, SANDEEP <sandeepkunc...@gmail.com> wrote: >> >>> >>> Dear All, >>> I require a macro for Cell Validation and drop down list - for 2nd >>> column as described below >>> >>> 1st column contains the list of Items(Product Names) for which i have >>> given a Validation and cell drop down >>> 2nd column - I want the validation and cell drop down to contain only the >>> specification for the product selected in the First Column. For example if >>> i select the product Bottle Oval in 1st column - in the second column drop >>> down i should get only the specification available for Bottle Oval such as 5 >>> ml; 10 ml; 50 ml. >>> >>> the list of Product and Specification master available is as follows >>> >>> Product 1 >>> >>> Specification 1 >>> >>> Product 1 >>> >>> Specification 4 >>> >>> Product 1 >>> >>> Specification 6 >>> >>> Product 1 >>> >>> Specification 10 >>> >>> Product 2 >>> >>> Specification 4 >>> >>> Product 2 >>> >>> Specification 10 >>> >>> Product 3 >>> >>> Specification 1 >>> >>> Product 3 >>> >>> Specification 2 >>> >>> Product 3 >>> >>> Specification 3 >>> >>> Product 3 >>> >>> Specification 4 >>> >>> Product 3 >>> >>> Specification 5 >>> >>> Product 3 >>> >>> Specification 6 >>> >>> Regards, >>> Sandeep >>> >>> >>> >>> >> >> >> -- >> Thanks & Regards, >> >> Harmeet Singh >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
sandy.xls
Description: MS-Excel spreadsheet