Delete entire row that contains specific prefix

**paradise2sr** · 03-25-2023, 03:41 AM

Hi,

I have data from A3:AW.What I want is that,
1.I want to delete entire row that contains KC/***,SX/*** in column T
2.sort S column date from oldest to newest in format > 13-Feb-2023

**Pepe Le Mokko** · 03-25-2023, 03:45 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Delete entire row that contains specific prefix

LinkBack

Thread Tools

Rate This Thread

Display

Delete entire row that contains specific prefix

Re: Delete entire row that contains specific prefix

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete entire row based on specific criteria

[SOLVED] Macro - delete entire row if cell contains specific value

[SOLVED] Delete entire row that does not contain specific data

[SOLVED] Delete entire row for specific words

[SOLVED] Delete workbooks with specific prefix in its name

[SOLVED] Macro to copy an entire worksheet from one open workbook to another with a specific prefix

Delete entire row from A to F if cell A has specific content

Bookmarks

Bookmarks

Posting Permissions