Thanks dilip ......... On Wed, Oct 13, 2010 at 5:51 PM, Dilip Pandey <dilipan...@gmail.com> wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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
