Hi Umesh,
I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Sunday, January 23, 2011 7:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram <vikramahuj...@gmail.com> wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: Code Category 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- ---------------------------------------------------------------------------- ------ 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