*hi rajan thnks for such nice helps ... due to size & sensitive data in file i cant upload them....
cant be there any vba codes for auto change in data validation list one by one , and the result which came ,get pasted in other sheets.....this is what i needed... i just want results get pasted in other sheet, by auto change of data validation. like this first a macro change the data validation , and then paste the value in other sheet in front of data validation value( by using lookup or vlookup function ofcourse)....and then repeat this process till the end of data validation list .....u can use combo box for this.also... * * *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 9:29 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
