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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
