+ Reply to Thread
Results 1 to 3 of 3

Need to generate summary based on employee & location info available in details sheet

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

    Need to generate summary based on employee & location info available in details sheet

    Kindly advise
    Attached Files Attached Files
    Last edited by aleanboy; 10-07-2014 at 04:33 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Need to generate summary based on employee & location info available in details sheet

    Could you elaborate?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

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

    Re: Need to merge rows with similar locations

    Hi All,

    Please help me with this.

    I have data of location & respective employee names in details sheet starting from row 6 till depends on day to day basis.
    On clicking submit button, it should first sort by locations and then merge all the locations that are similar.
    In short I need the final result as shown in sheet2,
    but note: result should be in details sheet only. That is merging & final output should be in details sheet only.
    I have created Sheet2 just for reference.

    Kindly provide a macro for this.
    Attached Files Attached Files

+ 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. Need to update location & Rep names based on data availabe in sheet "details"
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2014, 04:35 PM
  2. [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
  3. Populate summary sheet (insert & index rows from info in columns on another sheet)
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2011, 01:54 PM
  4. Automatically enter details in Summary sheet when new sheet created
    By unley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2010, 05:13 PM
  5. How to generate a list of tab names in a summary sheet
    By deanJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2009, 06:16 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