Re: $$Excel-Macros$$ Dynamic Data Validation Issue *

2013-02-18 Thread Hilary Lomotey
Oh Thanks Ashish, you are a life saver. great. working excellently. On Mon, Feb 18, 2013 at 5:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Dynamic Data Validation Issue

2013-02-18 Thread ashish koul
try the attachment see if it helps On Mon, Feb 18, 2013 at 10:17 PM, Hilary Lomotey wrote: > Hello Gurus, > > Hope i find you well. i am faced with a slight challenge and i kindly ask > for ideas on this. The issue is in sheet one is my cashbook. under the > main ledger i have the 5 main cate

Re: $$Excel-Macros$$ Dynamic data validation

2012-04-18 Thread dguillett1
http://www.contextures.com/xlDataVal13.html Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: chhajersandeep.s...@gmail.com Sent: Wednesday, April 18, 2012 4:50 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic data

$$Excel-Macros$$ Dynamic data validation

2012-04-18 Thread chhajersandeep . smca
Dear sir, I want dynamic data validation(list) where my name range to be dynamic. Example: Group containing cell are in G2:dynamic range. For every group I have sub group. The range of subgroup is also should be dynamic. I can use fixed range with indirect function and name range but not dynamic