+ Reply to Thread
Results 1 to 4 of 4

Need to display only unique employee name in summary - need some corrections in below code

  1. #1
    Forum Contributor
    Join Date
    09-15-2014
    Location
    london
    MS-Off Ver
    2013
    Posts
    111

    Need to display only unique employee name in summary - need some corrections in below code

    Hi team,

    Need small alteration with below code (Attached macro file for your reference).
    In details sheet I have employee “John” listed twice who is working under location “ARZN”. On clicking submit button in attached file, I need to have John displayed only once with qty as “187”.

    Please advise.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need to display only unique employee name in summary - need some corrections in below

    add this macro to your code:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-15-2014
    Location
    london
    MS-Off Ver
    2013
    Posts
    111

    Re: Need to display only unique employee name in summary - need some corrections in below

    Hi,
    Thanks for the code, but your code removes the duplicate names from details sheet which is not the thing I'm expecting. What I need is , if same employee is working under two different locations, then it should display the employee name twice, similarly if under same location employee is listed twice then it should sum the qty and display the name only once,

  4. #4
    Forum Contributor
    Join Date
    09-15-2014
    Location
    london
    MS-Off Ver
    2013
    Posts
    111

    Re: Need to display only unique employee name in summary - need some corrections in below

    Hi,
    Thanks for the code, but your code removes the duplicate names from details sheet which is not the thing I'm expecting. What I need is , if same employee is working under two different locations, then it should display the employee name twice, similarly if under same location employee is listed twice then it should sum the qty and display the name only once,

+ 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. Replies: 2
    Last Post: 10-09-2014, 05:18 AM
  2. [SOLVED] Formula to calculate unique values for an employee
    By irishguurl in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-16-2013, 03:15 PM
  3. [SOLVED] Need to aggregate employee timesheets into a summary sheet
    By cfell in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-23-2013, 02:03 PM
  4. Grab unique values affiliated with a unique employee
    By texaschili in forum Excel General
    Replies: 2
    Last Post: 07-13-2010, 10:52 AM
  5. automated employee tenure summary using Customized Charts with VBA
    By tweety127 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-22-2006, 02:24 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