+ Reply to Thread
Results 1 to 6 of 6

Deleting last entry by the user

  1. #1
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    272

    Deleting last entry by the user

    Good day!

    Is there any way to delete the last entry by the user in worksheet using macro? I've attached the file and the desired result sheet would be the desired output.

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Deleting last entry by the user

    Hi 323100N,

    When you say last entry by user... you just mean delete all the rows that have the same date/time as the bottom row? Or is part of the criteria the "name" column as well?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Deleting last entry by the user

    If the above understanding was correct, and date/time is the only criteria, then try this:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    272

    Re: Deleting last entry by the user

    Thank you for the information also the date,value name and location are part also of the criteria

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Deleting last entry by the user

    In your example Location is blank for all the rows you deleted, except for row 6. Value also keeps changing... so I don't understand how your example illustrates what you want, unless I am mis-understanding, which is possible of course

    Let's start over.

    You want to delete the bottom row obviously, since that is definitely the last entry. What else needs to be the SAME in the rows above that, to be deleted also?

  6. #6
    Forum Contributor 323100N's Avatar
    Join Date
    08-11-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    272

    Re: Deleting last entry by the user

    oops sorry I was confused by the criteria. Everything is working properly and your code fits to what desired result. Thank you

+ 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. Data entry but restricted from deleting
    By jediknight in forum Excel General
    Replies: 6
    Last Post: 01-10-2017, 12:07 PM
  2. Manual Entry without deleting formula
    By gzoeller in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2015, 08:44 AM
  3. Column entry deleting issue
    By jonboy6257 in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-03-2014, 05:28 PM
  4. deleting an entry in a userform
    By bsizzle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2013, 08:01 PM
  5. Deleting Oldest Entry
    By markrennolds in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2010, 02:30 PM
  6. Deleting an entry from a ini file
    By vqthomf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2005, 03:05 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