+ Reply to Thread
Results 1 to 3 of 3

Fetching Customer ID's and putting it in ascending order in Report Sheet

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    India
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    40

    Fetching Customer ID's and putting it in ascending order in Report Sheet

    Need to know a way to fetch the customer ID and its matching customer name from the sheet "Customer List" and put in a ascending order of Customer ID in the Sheet "Reports". once I added a new customer in the sheet "customer list" it should be automatically updated in the sheet "Reports". the automatically populating sheet "Report" must have uniq customer ID ( I mean, there should not be any duplication)

    Is there anyway to do this... currently i am doing this manually.

    my file is attached!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,801

    Re: Fetching Customer ID's and putting it in ascending order in Report Sheet

    I presume you add new customers to the customer list sheet at the bottom of the existing list, and allocate a new unique ID at the same time. I've amended the formulae in your Reports sheet to accommodate this and copied down to row 31. I've also amended your formulae in the Sales sheet to avoid the errors you were showing.

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-15-2011
    Location
    India
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    40

    Re: Fetching Customer ID's and putting it in ascending order in Report Sheet

    It worked for me... Thank You Pete_UK , really thanks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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