There is another way to do this using Named Ranges and the "Indirect ()" Function
Let me know if you are interested On Apr 14, 2:03 pm, Prashant Pednekar <prashant...@gmail.com> wrote: > On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv > <suryaprasad...@gmail.com>wrote: > > > Prashant, > > > Can you post me a sample file so that i can help you out > > > Cheers > > Surya > > > 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 > > > > sandy.xls > 18KViewDownload --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
