Hi Mahesh, firslty thanks for your great favour it is working fine but some times it happen to ask the path2 name
i created one folder with dump and created one sub folder as Working then i placed the Before After Entry sheets dump.xls , Global Company Code List .xls in both dump folder and subfolder also. Apart from this macro is working fine. one small modification as u told region is already in sheet so need to pull from global company code, i tried removing vlookup code for region but it is not working can u plz help in this concern. Regards, Prathima On Sun, May 8, 2011 at 9:55 PM, Mahesh parab <mahes...@gmail.com> wrote: > Hi Prathima > > have done with few steps till pivot table, pls check > > On Wed, May 4, 2011 at 12:19 AM, Prathima R <prathima....@gmail.com>wrote: > >> Hi Mahesh, >> >> Firstly thanks for the reply , i have placed the steps in detail in word >> document. >> >> first open the attach file and move the same data in to two work books >> >> and rename onework book as MV Report Data(DD MM YY).xls >> >> >> >> and other one as Workings (DD MM YYYY) >> >> >> >> After performing the above two steps >> >> >> >> Open the Workings (DD MM YYYY) as we have two sheets Before and After. >> >> *Before entry sheet* >> >> 1) Go to Before sheet Column A (*Mark view Queue Name*) then >> apply filter and delete all the rows Except Comment request rows. Ensure to >> have data for only Comment Request. >> >> 2) Then remove the filter Go to Column M (Company Name) after this >> column insert one column >> >> And rename the column heading as region .Update the region column data >> using Vlook up from >> >> Global Company Code List .xls with help of company codes. Before doing >> vlookup Do text to columns in* company code column L (Please find the >> Global company code list sheet attached ) * >> >> >> >> On Mon, May 2, 2011 at 1:49 PM, Mahesh parab <mahes...@gmail.com> wrote: >> >>> Hi >>> >>> it would be great if u could explain some steps; it seems confusing, keep >>> it as simple as you can; >>> which is the first step, what are the 6 vlookups ? which workbook contain >>> base data of your pivot. >>> >>> >>> On Mon, May 2, 2011 at 10:07 AM, Prathima R <prathima....@gmail.com>wrote: >>> >>>> Hi Experts, >>>> >>>> >>>> Due size constance i am sending in two zip folders please check second >>>> mail for excel files dump. >>>> >>>> (This is Second mail please check this one as well -- thanks >>>> for cooperation) >>>> >>>> This report is sent on daily basis please help in this concern if it is >>>> automated >>>> it could be very much thankful really wonderful thing . please find the >>>> attached sop and zipped folder which contains all the raw data . >>>> >>>> Please kindly help in this concern if it is possible . >>>> >>>> it has 6 v lookups and two pivot tabs. >>>> >>>> Thanks for your help in advance. >>>> >>>> Regards, >>>> Prathima >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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
