Hi Rajasekhar, I believe you are using Excel 2007, this is what I have figured out after seeing your example of Pivots. I would suggest you to record macro with all the steps which you are doing manually and then try editing those codes as per your automation needs.
Alternatively, if you break down your manual steps in smaller steps, then I can give a try on this. See doing it all from scratch is slightly time consuming and now-a-days I am little occupied and unable to devote that much time. :( Best Regards, DILIPandey On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > > > ---------- Forwarded message ---------- > From: rajasekhar praharaju <rajasekhar.prahar...@gmail.com> > Date: Tue, Oct 12, 2010 at 5:49 PM > Subject: Re: $$Excel-Macros$$ Please help > To: Dilip Pandey <dilipan...@gmail.com>, excel-macros@googlegroups.com > > > hi Dilip, > > firstly i will be copying the pivot table from task distribution sheet. > > > Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA 15 > RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250 > > > this part from task distribution sheet and click on extension bar (+) to > get the individual line items for all. > > then place the name which is listed on the top of the batch against their > respective lineitems . > > like this ......... > > > Row Labels Sum of # of no hits DEEPTI 45 3 1 4 2 6 1 8 1 9 1 11 1 12 1 > 15 2 292 1 300 2 301 1 302 2 304 2 305 1 418 10 561 2 562 1 573 3 574 5 > 735 1 742 4 LAKSHMI 35 288 6 394 5 420 2 422 6 429 1 564 2 565 7 569 1 737 > 5 NIKHIL 46 289 3 293 6 306 1 396 6 397 3 424 4 425 4 427 3 566 4 571 4 > 576 4 739 4 PUSHPA 15 287 10 295 5 RAVI 7 285 4 286 3 SAI 35 296 4 297 3 > 298 1 398 6 399 3 423 5 568 1 572 5 578 5 740 2 VENKAT 46 284 13 290 2 308 > 2 309 2 311 1 416 4 421 5 563 8 570 3 736 6 ARVIND 21 16 3 283 3 299 2 307 > 1 395 3 419 1 428 5 430 1 741 2 Grand Total 250 > here the first column is Batch # and second column is their number of hits. > > Please find the word file attached i will assign names as follows. > > After this ill do v-lookup in the sheet where the data is pasted . > > > comparing the task distribution sheet orginal with Task distribution > sheet. > > 1) ill take batch number from task distribution orginal sheet which is in > column c as Lookup value. > and table array as the data pasted in new sheet earlier.(pivot table > data which is pasted using paste special and then assigned names to it) > and Purpose of this vlook is to know get the pending batches billers names. > > those batches which are left in task distribution sheet that batches as > well as their names should appear. > > Please advise is it possible. it could be very much helpful. > > Thanks, > Raj > > > > > On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Dear Rakasekhar. >> >> I am not able to understand your problem actually... :( >> How you are assigning the names against tasks ? >> >> I believe creating a pivot table and then using "Show Pages" option >> you can assign the tasks to different individuals. >> >> Please explain further if you need some other solution. >> >> Best Regards, >> DILIPandey >> >> >> >> On 10/9/10, rajasekhar praharaju <rajasekhar.prahar...@gmail.com> wrote: >> > could you please assist me in this concern .please >> > >> > actually if any batch is pending using vlookup i used to find their >> > respective names >> > how is this possible through sumif please suggest . >> > >> > On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS <svyas0...@gmail.com> >> wrote: >> > >> >> Dear Rajasekhar >> >> >> >> >> >> Please use u Sumif Formulas. >> >> >> >> Regards >> >> >> >> Sumit Vyas >> >> >> >> >> >> >> >> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju < >> >> rajasekhar.prahar...@gmail.com> wrote: >> >> >> >>> >> >>> >> >>> hi Excel Guru, >> >>> >> >>> >> >>> Please assist me in this concern . >> >>> >> >>> >> >>> Attached are two sheets Task distribution orginal and other sheet with >> >>> task distribution >> >>> >> >>> >> >>> My daily activity is to do vlookup and firstly i will copy the pivot >> >>> table >> >>> from task distribution sheet orginal and paste special in one new >> excel >> >>> sheet then compare it with another sheet which is task distribution >> >>> sheet. >> >>> >> >>> >> >>> 1) Prepare vlookup to find the batches which are pending . >> >>> >> >>> >> >>> once i perform vlookup it will display the names against the batches. >> >>> which are pending . >> >>> >> >>> >> >>> Please advise is this possible through vba. >> >>> >> >>> >> >>> Thanks for your help in advance., >> >>> >> >>> Raj >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> -- >> >>> >> >>> >> ---------------------------------------------------------------------------------- >> >>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >>> >> >> >> >> -- >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >> >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
