×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Delete a row in a filtered table - next to another table

Delete a row in a filtered table - next to another table

Delete a row in a filtered table - next to another table

(OP)
One annoyance for me is not being able to delete a table row when the table is filtered and there's another table occupying the same row on that same worksheet. So I was going to write a macro to do this for me.

I searched the internet and couldn't find another solution so of course I came here as y'all are fantastic and have helped me, gosh, going back to 2002 (I had a different account way back then). I digress.

Thinking out loud, my proposed solution would be:

  • Make note of the row(s) (by row number) that are selected to be deleted.
  • Make note of the filter that is currently applied.
  • Unfilter the table.
  • Delete the rows in the table.
  • Re-filter the table.
  • Set the active cell to be on the next row after the ones that were deleted. (I guess a user preference...)
So questions:
  1. Does Excel have something built-in that does this automatically already?
  2. Do any of y'all already have something written that does this? If so would you share it?
  3. If no one has anything existing, does this sound like an appropriate method? If not, what would you change?

Thanks!!


Matt

RE: Delete a row in a filtered table - next to another table

If I understand what you are trying to do, I think you may be over complicating this.

First apply your filter.

Now select the cells that you want to delete.

Right click on the cells and select "Delete" and then select "Shift cells up".

Now remove the filter and see if you have the result you wanted.

Apologies if my terminology is not quite right but I do not have excel available at the moment.

RE: Delete a row in a filtered table - next to another table

Matt,

If your tables are Structured Tables, there's way to select table rows for deletion that does not include entire rows.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close