est.
>> >>>
>> >>> On 7/6/13, ravinder negi wrote:
>> >>> > PFAtry this and advise if this does not work propery.. you just
>> >>> > need
>> >>> to
>> >>> > copy paste formula in validation rng
ose will be also add in list...but your second sheet data should
>> > formated as given by you.
>> >
>> > --- On Sat, 7/6/13, Mangesh Vimay wrote:
>> >
>> > From: Mangesh Vimay
>> > Subject: Re: $$Excel-Macros$$ To create drop down list for ma
re
> data
> > and those will be also add in list...but your second sheet data should
> > formated as given by you.
> >
> > --- On Sat, 7/6/13, Mangesh Vimay wrote:
> >
> > From: Mangesh Vimay
> > Subject: Re: $$Excel-Macros$$ To create drop down li
e:
>
> From: Mangesh Vimay
> Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per
> many lists
> To: excel-macros@googlegroups.com
> Date: Saturday, July 6, 2013, 11:20 AM
>
> Hi Be Tran Van,
>
> Thank you for your quick help.
>
> Howev
Simply Great !!!
Could you please share final workbook.
Sorry, for this.
Thanks a ton !!!
On 7/6/13, vba wrote:
> Hi
>
> You dont have to create name, this will be created programatically for data
> in DATA sheet.
>
> Just copy paste B2 or drag down.
>
>
> Hoe Name is created by this Macro:
>
Hi
You dont have to create name, this will be created programatically for data
in DATA sheet.
Just copy paste B2 or drag down.
Hoe Name is created by this Macro:
First Data sheet is sort on the basis of ID; then unique ID is pasted in
range J2 & downwards. Then Name is defined for each ID begi
Hi,
Thanks for the help.
But, how to create data validations in the first sheet based on the
list which you have retrieved by using code.
Please help.
On 7/6/13, vba wrote:
> Hey
>
> PFA.
>
> HTH
>
>
> On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay
> wrote:
>
>> Hi Be Tran Van,
>>
>> Thank you
Hey
PFA.
HTH
On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay wrote:
> Hi Be Tran Van,
>
> Thank you for your quick help.
>
> However, in my original workbook there are total 1200 lists and its
> quite time consuming job to create named range for all 1200 lists and
> then to specify the source f
Hi Be Tran Van,
Thank you for your quick help.
However, in my original workbook there are total 1200 lists and its
quite time consuming job to create named range for all 1200 lists and
then to specify the source for all the lists for data validations.
Could you please suggest shortcut way/method
