+ Reply to Thread
Results 1 to 5 of 5

merge rows with latest date showing

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    merge rows with latest date showing

    hi
    on sheet 2 I have a list of multiple items that I want to merge ,macro100 does this nicely but for the life of me I can not get the latest date showing
    it should be f222 and the last date is the 28/10/14 ,everything else works as should ,has anyone got any ideas please
    cheers colin
    F222 PUMP 100 UNIT REMOVED FROM PLANT,REPAIRED / INSPECTED,UNDER REPAIR,BROKEN IMPELLOR,RETURNED TO STORES/ E23 BAY,RETURNED TO STORES/ E23 BAY,RETURNED TO STORES/ E23 BAY 12/12/2014 COMPLETED 240890
    this is how should look but with the date of 28/10/2014
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-01-2012
    Location
    Montreal, Qc, Canada
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: merge rows with latest date showing

    Hi,

    I used the data that was on sheet 2... the oldest date was 10/22/2014 .. see code below... if its not exactly what your looking for it will at lease give you an idea on how to play with the dates..

    ( i used your code and added an extra verification)

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: merge rows with latest date showing

    hi
    many thanks for the info ,not sure what it does but will google later and have another go
    cheers colin

  4. #4
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: merge rows with latest date showing

    hi did not use yours in the end ,took some working out but its here
    cheers colin

    Please Login or Register  to view this content.
    Last edited by cfinch100; 08-28-2015 at 01:48 PM.

  5. #5
    Registered User
    Join Date
    08-01-2012
    Location
    Montreal, Qc, Canada
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: merge rows with latest date showing

    no problem if you didnt use mine. Just glad you find your solution...

+ 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: 8
    Last Post: 04-08-2015, 10:10 PM
  2. Need help showing the latest value on balance column for a particular item.
    By kittle08 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-31-2014, 10:17 AM
  3. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  4. Delete duplicate rows, but keep the cell that has the latest date
    By vaznlyfe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2012, 01:35 PM
  5. Chart showing only latest data entries
    By RickDM in forum Excel General
    Replies: 0
    Last Post: 08-15-2011, 03:04 PM
  6. Excel 2007 : Showing an the latest updated cell
    By Richmate in forum Excel General
    Replies: 8
    Last Post: 04-07-2010, 11:32 AM
  7. Find the latest Date from one column across particular rows
    By pmarsella in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2009, 01:27 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