thnks rajan ....this is what i needed.... this is really very nice of you....it ease my work load...
now one more query....in attached file...sheet "gents report"....cell C2 value should get pasted in sheet "gents"...in the front of row having staff no.. example is shown..if income tax calculation show "error"...ignore that data for pasting .. Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote: > See if it helps > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Friday, July 01, 2011 5:17 PM > To: excel-macros > Subject: Re: $$Excel-Macros$$ need required for data validation value query > > sorry , i forget to attach a sample file in my query.. > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Fri, Jul 1, 2011 at 5:14 PM, ankur <ankurpande...@gmail.com> wrote: >> hi ayush/ all members >> >> i have one data validation list, which is required in formula to get >> a result.... i want the all results corresponding to each value in >> different sheet or in different column in one click any macro code is >> there ?.... >> >> thanks in advance >> >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> -- >> ---------------------------------------------------------------------- >> ------------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
