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
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
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.
If the above understanding was correct, and date/time is the only criteria, then try this:
Please Login or Register to view this content.
Thank you for the information also the date,value name and location are part also of the criteria
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?
oops sorry I was confused by the criteria. Everything is working properly and your code fits to what desired result. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks