+ Reply to Thread
Results 1 to 5 of 5

Analysisi the Top 26 vendors from among all on a new sheet.

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    319

    Analysisi the Top 26 vendors from among all on a new sheet.

    Pl.refer my attach file.

    I want with the help of VBA codes to insert a new sheet for doing the analysis of top 26 vendors ( Pick-up the Highest Total from column 'I' of the vendor from 'summary' sheet ) details from the 'Summary'sheet.

    Is it possible through the VBA codes help?
    Attached Files Attached Files
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: Analysisi the Top 26 vendors from among all on a new sheet.

    does it have to to be VBA, and how do you want to handle duplicates? (for instance, you have 6 values that are 55)

    You could use a LARGE() function for this, if you want to use a fomrula
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    319

    Re: Analysisi the Top 26 vendors from among all on a new sheet.

    Refer my earlier attach file and can it be possible to convert the working from 'summary' sheet to 'Analysis' sheet with the help of VBA codes?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: Analysisi the Top 26 vendors from among all on a new sheet.

    Yes I looked at your workbook before I posted my 1st post, you still did not answer either of my questions?

  5. #5
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    319

    Re: Analysisi the Top 26 vendors from among all on a new sheet.

    Sir,

    Sorry for that.
    If it is repeating the same value e.g.55 in thrice or more times,then,all the values should appear till the limits i.e.26.
    Last edited by PRADEEPB270; 11-25-2013 at 03:54 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic emails to vendors with data
    By Manic1525 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2013, 03:53 AM
  2. Minimization of numbers of vendors
    By Jowi7991 in forum Excel General
    Replies: 5
    Last Post: 06-18-2012, 09:50 AM
  3. monthly/yearly expence by vendors
    By Nikki in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2006, 04:10 PM
  4. [SOLVED] Multiple vendors and scenarios - Excel
    By Vincent Kelly via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2005, 01:06 AM
  5. [SOLVED] VBA Code to list vendors
    By Andri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1