You should attached all Sheets so that I can Link Main Sheet with each other.
-----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Monday, July 04, 2011 2:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need required for data validation value 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 Mon, Jul 4, 2011 at 12:08 PM, ankur <ankurpande...@gmail.com> wrote: > file attached....again forget to attach file 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 Mon, Jul 4, 2011 at 11:53 AM, ankur <ankurpande...@gmail.com> wrote: >> 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 -- ---------------------------------------------------------------------------------- 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