91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 28 May 2012 1:56
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Dynamic List range fo
>>> Please find the attached Sheet
>>>
>>> *It provide you a dynamic and sorted list in List Validation*
>>>
>>> ** **
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838
olumn1 and formula will fill Down automatically.*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSAR
-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Seraj Alam
>> *Sent:* 17 May 2012 11:07
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Dynamic List range f
legroups.com] *On Behalf Of *Seraj Alam
> *Sent:* 17 May 2012 11:07
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Dynamic List range for Data validation
>
> ** **
>
> Hi,
>
> ** **
>
> U can use this formula in data validation for dynamic
try
Sub setdvlist()
With Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
.Name = "dvlist"
End With
With Range("b2").Validation
.Delete
.Add Type:=xlVal
Thanks to all! I will try and revert back to you!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 17 May 2012 04:21:51
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Dynamic List range for Data validation
Hi,
U can use this formula in data validation for dynamic range
=OFFSET($A$1,0,0,COUNTA(A:A),1)
And also find the attached sheet with example hope it will help you what u
are looking for
On
Give a try to this link..
http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Thu, May 17, 2012 at 11:07 AM, Seraj Alam wrote:
> Hi,
>
> U can use this formula in data validation for dynami
Hi,
U can use this formula in data validation for dynamic range
=OFFSET($A$1,0,0,COUNTA(A:A),1)
And also find the attached sheet with example hope it will help you what u
are looking for
On Wed, May 16, 2012 at 9:21 PM, wrote:
> Dear all,
>
> I want to create a list in data validation whic
10 matches
Mail list logo
