Re: $$Excel-Macros$$ need required for data validation value query
*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 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 wrote: > > file attachedagain 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 wrote: > >> thnks rajan this is what i needed > >> this is really very nice of youit ease my work load... > >> > >> now one more queryin 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 > 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 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 h
RE: $$Excel-Macros$$ need required for data validation value query
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 wrote: > file attachedagain 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 wrote: >> thnks rajan this is what i needed >> this is really very nice of youit ease my work load... >> >> now one more queryin 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 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 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 >>> >>> <><><><><><><><><><><>
RE: $$Excel-Macros$$ need required for data validation value query
Hi ankur Attachment Not Found.. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Monday, July 04, 2011 11:53 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need required for data validation value query thnks rajan this is what i needed this is really very nice of youit ease my work load... now one more queryin 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 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 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.
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 wrote: > file attachedagain 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 wrote: >> thnks rajan this is what i needed >> this is really very nice of youit ease my work load... >> >> now one more queryin 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 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 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 1revised Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need required for data validation value query
thnks rajan this is what i needed this is really very nice of youit ease my work load... now one more queryin 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 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 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
RE: $$Excel-Macros$$ need required for data validation value query
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 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 Copy of Book5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need required for data validation value query
hi rakesh thnks for reply this is not a simple vlookup formula case, i just want to get figure by changing validation list..because calculation is having many backhand formulas... well... i want you tell that...this income tax calculation sheet sample.the result which is showing is net income tax payable on month wise..so i have to calculate it manually and than use the tax amount in the employees payroll sheet.so i need only paste special value for data entry, how can i get value in different sheet , when i change data validation, 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 8:05 PM, ICWAI Help wrote: > > Please find the attached file. > > Thanks, > Rakesh. > On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote: >> >> I'm not sure if I understand what you want correctly. >> >> O2 cell in your sample file >> you can have the following formula >> =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) >> then do autofill .. >> Is this what you want? >> >> >> -- >> >> -- >> 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
Re: $$Excel-Macros$$ need required for data validation value query
Please find the attached file. Thanks, Rakesh. On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote: > I'm not sure if I understand what you want correctly. > > > O2 cell in your sample file > > you can have the following formula > > =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) > > then do autofill .. > > Is this what you want? > > > > -- > > -- > 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 Book5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need required for data validation value query
I'm not sure if I understand what you want correctly. O2 cell in your sample file you can have the following formula =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) then do autofill .. Is this what you want? -- -- 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
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 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 Book5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ need required for data validation value query
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