filter and delete

  1. M

    Deleting filtered Rows

    Hi I have used this code on a sheet and it was working before but now it is giving me error 1004 Dim SelectedCell, Cell, rng As Range Dim tbl As ListObject Dim x As Long, i, y As Long Dim hdr_Row As Long, last_row As Long, lastdata_row As Long Worksheets("meetingTemplate").Activate For Each...
  2. P

    How can I delete hidden rows after filter has been set?

    Hi, I currently have a workbook with multiple sheets that have a macro running to set a filter based on specific criteria from the main sheet. I would like to be able to have all items that are not a part of the filter (hidden) be deleted from the supporting sheets in an effort to reduce the...
    • pensix
    • Thread
    • application.cutcopymode delete rows false filter and delete vba
    • Replies: 3
    • Forum: Excel Questions
  3. X

    Deleting Rows that meet filtered criteria only in a table

    Hi If I filter a table and the filtered result is what needs to be deleted (nothing else), How do i go about writing code to select the filtered rows to be deleted only (not the headers) within the Table or the rest of the worksheet?
  4. T

    Choose Selection from User Dialog

    Hello, I need to make a dialog after I open a sheet so the user is only looking at the info that pertains to them. There is a column that categorizes the row into 1 of 14 categories. I want to delete every row that does not pertain to the user some users have multiple categories and some just...
    • timmytonga
    • Thread
    • dialog box vba filter and delete multiple criteria user selectected range
    • Replies: 0
    • Forum: Excel Questions
  5. C

    Loop Through Table to Delete Unwanted Rows of Data

    Hello, I am currently working on an automation project where I am receiving raw data of the parts in our inventory. I am then wanting to sort through the raw data to delete the unwanted rows of data, and then compare that "filtered" data to a set list of needed part numbers. The below loop is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top