Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
gt; *Sender: * excel-macros@googlegroups.com > *Date: *Mon, 1 Jul 2013 21:12:36 +0530 > *To: *excel-macros@googlegroups.com > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic > name range! > > Pl ignore earlier & tr

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Pl ignore earlier & try this Soln thru VBA. Thanks On Mon, Jul 1, 2013 at 8:41 PM, Vabs VBA wrote: > Hi > > Weird but its working now. > > Thanks > > > On

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi In data validation indirect function doesnt work when you you refer to volatile data. You can create a table to accommodate your data. PFA. Thanks On Mon, Jul 1, 2013 at 6:53 PM, wrote

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
my BlackBerry® from Vodafone > -- > *From: * chhajersand...@gmail.com > *Date: *Mon, 1 Jul 2013 10:39:12 + > *To: *excel-macros > *ReplyTo: * chhajersand...@gmail.com > *Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic > na

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
ccordingly. Thanks. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 15:24:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data val

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
nt on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 15:24:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name rang

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Subject: *Re: $$Excel-Macros$$ Dependent Data validation with Dynamic > name range! > > Hi > > Pl share youe excel file. > > Thanks > > > On Mon, Jul 1, 2013 at 10:07 AM, wrote: > >> Dear Excel expert! >> >> I am stuck at a point! I have kept five dyn

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
Subject: Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, wrote: > Dear Excel expert! > > I am stuck at a point! I have kept five dynamic name range using offset > funtion viz Grouping

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, wrote: > Dear Excel expert! > > I am stuck at a point! I have kept five dynamic name range using offset > funtion viz Grouping which has a co

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, wrote: > Dear Excel expert! > > I am stuck at a point! I have kept five dynamic name range using offset > funtion viz Grouping which has a component like liabilities, asset, income > and expenses. And also have created dynam

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread chhajersandeep
@googlegroups.com Subject: $$Excel-Macros$$ Dependent Data validation with Dynamic name range! Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name

$$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-06-30 Thread chhajersandeep
Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am u