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 resp...@gmail.com 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

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 koul.ash...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup

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

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