Hi guys,
I have a table that looks like this:
J5 Delete 52 G6 Hera 15 B4 Afrodite 42 M4 Delete 41 W1 Apolo 33
I want to delete the row and move up (from colum A to C) where there is "Delete" on column B.
I can't delete the entire row because I have other data on the side of it.
Last edited by heuder; 10-21-2015 at 09:38 AM.
Try:The macro assumes your data is in columns A, B and C and that it starts in row 2.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you for your help Mumps1,
But is not working, it does nothing.
Maybe I'm doing something wrong? =(
When I tested the code on the data you posted, it worked correctly. Perhaps your data is organized differently. Can you post a copy of your file?
It's working, sorry.
Apparently, I think the problem was with Uppercase on the code.
On my cells I have "delete" and on the code was "Delete", does that make sense?
Well, it's working know, thank you.
That certainly makes sense. Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks