filmov
tv
How to Delete Rows Based on Criteria in Microsoft Excel
Показать описание
*How to Delete Rows Based on Criteria in Microsoft Excel*
In this advanced excel tutorial, you’ll learn to delete rows based on criteria in Microsoft Excel. I’ve created a similar video on where I used Excel’s built-in feature and here is the link for you to consider.
Also, I’ve created several videos on copying rows to different worksheet based on criteria and they are as follows:
Now in this video I’ve use VBA to solve this and here is how it works:
Suppose you have a workbook where you have data, and you need process it. This could be a lead generation workbook, invoicing workbook, or even a project management workbook. The focus is to delete rows that are not important to you based on a specific criterion.
Now follow the instruction below to Remove Rows Based on Text in Excel:
*Step 2:* Click on Visual basic, Insert and then Module.
*Step 4:* Close the VBE (Visual Basic Editor)
*Step 5:* Save the workbook in .xlsm format if you wish to keep this feature for the future
*Step 6:* Click on “Macro” from the developer tab and Run the code named “DeleteRowsBasedOnCriteria”
*Step 7:* Select the column where you have your criteria and click ok
*Step 8:* Write the specific text or criteria and click ok. Remember this is case sensitive so you need to write exactly as it is written on the specific column.
Done. Your rows will be deleted based on your specified criteria or text.
#DeleteRows #Excel #Rows
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
Here goes the most recent video of the channel:
Playlists:
Social media:
In this advanced excel tutorial, you’ll learn to delete rows based on criteria in Microsoft Excel. I’ve created a similar video on where I used Excel’s built-in feature and here is the link for you to consider.
Also, I’ve created several videos on copying rows to different worksheet based on criteria and they are as follows:
Now in this video I’ve use VBA to solve this and here is how it works:
Suppose you have a workbook where you have data, and you need process it. This could be a lead generation workbook, invoicing workbook, or even a project management workbook. The focus is to delete rows that are not important to you based on a specific criterion.
Now follow the instruction below to Remove Rows Based on Text in Excel:
*Step 2:* Click on Visual basic, Insert and then Module.
*Step 4:* Close the VBE (Visual Basic Editor)
*Step 5:* Save the workbook in .xlsm format if you wish to keep this feature for the future
*Step 6:* Click on “Macro” from the developer tab and Run the code named “DeleteRowsBasedOnCriteria”
*Step 7:* Select the column where you have your criteria and click ok
*Step 8:* Write the specific text or criteria and click ok. Remember this is case sensitive so you need to write exactly as it is written on the specific column.
Done. Your rows will be deleted based on your specified criteria or text.
#DeleteRows #Excel #Rows
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
Here goes the most recent video of the channel:
Playlists:
Social media:
Комментарии