Hi Dave and Team, Thanks for the help provided. I have done this successfully with out any issues.
once again thank you all for your valuable and swift response as well. Regards, Sharma On Wed, May 13, 2009 at 10:50 PM, Fabio Lemos <flnle...@gmail.com> wrote: > Hi, > It's possible to use Validation, but it need to be custom and you'll need a > auxiliar column. But Validation doens't have the possibility of warning in > some cases and error in other. I created a solution that uses validation for > the main rules and for the first "0" I used conditional formating. > > see the attached file. > > Regards! > > 2009/5/13 amrahs k <amrahs...@gmail.com> > > Hi Harmeet, >> >> I have attached one sample workbook that contains a query for data >> validation. >> >> I just need a macro for the same. >> >> Thanks for your help. >> >> Regards, >> Sharma >> >> On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh <harmeet.hew...@gmail.com >> > wrote: >> >>> Hi, >>> >>> Please see attached file. >>> >>> On Wed, May 6, 2009 at 5:53 PM, amrahs k <amrahs...@gmail.com> wrote: >>> >>>> Hi Team, >>>> >>>> I need your help it is very urgent! >>>> >>>> Thanks, >>>> Sharma >>>> >>>> ---------- Forwarded message ---------- >>>> From: amrahs k <amrahs...@gmail.com> >>>> Date: Wed, May 6, 2009 at 5:33 PM >>>> Subject: Help required >>>> To: gyanjai...@gmail.com >>>> >>>> >>>> Hi Jain, >>>> >>>> I have attached the sample spreadsheet that i was working upon for my >>>> project. The requirement would be- >>>> >>>> Count the data that has been entered in each cell under coulumn D6:D17, >>>> F6:F17, H6:H17 and so on. (every alternate column) >>>> >>>> I want the macro to evaluate the total count of each alternate coulumn >>>> though I have few conditions. >>>> >>>> condition 1: count all the data entered in each cell (text or numeric >>>> value) >>>> >>>> condition 2: do not count the data "NA" >>>> >>>> It would be helpful if the macro populated the result in a message box- >>>> >>>> Ex: The Total Count is "13" (The attached document has 17 data in the >>>> range D6:D17, what i want to exclude the value "NA" and produce the result >>>> as "13"). similarly for every alternate column. >>>> >>>> I believe you could do this since am not familiar with VBA macro. >>>> >>>> Thanx in advance. >>>> >>>> Regards, >>>> Sharma >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> Thanks & Regards, >>> >>> Harmeet Singh >>> >> >> >> >> > > > -- > Fabio L Lemos > > email: flnle...@gmail.com > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
