Re: $$Excel-Macros$$ VBA Code against VLOOKUP function
Dear Anil, Please see attached Sheet, -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jul 15, 2011 at 11:32 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Masters, ** ** Needed the VBA code which work similar to VLOOKUP function where I can call data from master worksheet to fill my report ** ** Attached file will explain you my requirement ** ** Master worksheet contains – GL Code master where each GL code has details and grouping While putting GL code in Report worksheet it should call the data from master worksheet and give me Group 1 and Group 2 ** ** ** ** Please help ** ** Regards, Anil Bhange ** ** ** ** -- -- 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 VBA_Code_for_VLOOKUP(Solved).xlsm Description: Binary data
RE: $$Excel-Macros$$ VBA Code against VLOOKUP function
Thanks Noorain, One more help please, If the GL code doesn't match can I able to color these cell in Red color Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday, July 15, 2011 12:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code against VLOOKUP function Dear Anil, Please see attached Sheet, -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ On Fri, Jul 15, 2011 at 11:32 AM, Anil Bhange anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com wrote: Hi Masters, Needed the VBA code which work similar to VLOOKUP function where I can call data from master worksheet to fill my report Attached file will explain you my requirement Master worksheet contains - GL Code master where each GL code has details and grouping While putting GL code in Report worksheet it should call the data from master worksheet and give me Group 1 and Group 2 Please help Regards, Anil Bhange -- -- 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.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto: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.commailto: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$$ VBA Code against VLOOKUP function
Dear Anil, Please see attached Sheet.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jul 15, 2011 at 12:54 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Thanks Noorain, ** ** One more help please, If the GL code doesn’t match can I able to color these cell in Red color ** ** Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Friday, July 15, 2011 12:31 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ VBA Code against VLOOKUP function ** ** Dear Anil, Please see attached Sheet, -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** On Fri, Jul 15, 2011 at 11:32 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Masters, Needed the VBA code which work similar to VLOOKUP function where I can call data from master worksheet to fill my report Attached file will explain you my requirement Master worksheet contains – GL Code master where each GL code has details and grouping While putting GL code in Report worksheet it should call the data from master worksheet and give me Group 1 and Group 2 Please help Regards, Anil Bhange -- -- 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 VBA_Code_for_VLOOKUP(Solved)(Colored).xlsm Description: Binary data