Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear?
Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram <vikramahuj...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
