You are welcome Suhas..!! As it is done using Data- Validations only, hence you would find it quite easy.
Reach out to me in case of any issues. Best of Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jan 5, 2010 at 1:26 PM, Suhas <chet...@gmail.com> wrote: > Thanks you very Much Mr Praveen and Mr Dilip, Its so easy :( > > > > On Jan 5, 12:28 pm, kvc praveen kumar <pkkara...@gmail.com> wrote: > > Hi, > > > > Please find attached the solution for your request. I implemented this > > using sheet events. So it will not work in other sheets. Only in sheet1 > this > > will work. > > > > Please check and let me know if you have any doubts. > > > > regards, > > praveen > > > > > > > > On Tue, Jan 5, 2010 at 11:58 AM, Suhas <chet...@gmail.com> wrote: > > > Hello All! > > > > > WIsh you all a happy new year, > > > > > I have a excel file with names of 250 people, and i have 12 columns > > > for each month, each month people nominate themsleves for a training, > > > the maximum limit is 30 members per month. The nominees are marked > > > with "X" for particular month. > > > > > If the count of X in the month reaches 30 excel should give a alert > > > and should direct the user with a pop up to use next month slot. I > > > tried to use counta and validation functions but its not working.. > > > > > can any one help me pls. > > > > > -- > > > > > > ---------------------------------------------------------------------------------- > > > Some important links for excel users: > > > 1. Follow us in TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > > >http://www.excelitems.com > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > If you find any spam message in the group, please send an email to: > > > Ayush Jain @ jainayus...@gmail.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > > HELP US GROW !! > > > > > We reach over 6,500 subscribers worldwide and receive many nice notes > about > > > the learning and support from the group.Let friends and co-workers know > they > > > can subscribe to group at > > >http://groups.google.com/group/excel-macros/subscribe > > > > > > > > TRAINING_CALENDAR.xls > > 60KViewDownload- Hide quoted text - > > > > - Show quoted text - > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
