RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Guys
I have this sheet B2B where there are some unwanted rows I want to remove. First I need to create, Move and make a copy of B2B sheet and rename the copy sheet to 2B, then I want to delete all the rows if those rows fulfill 2 conditions.
1. In the column H, the rows which contain Yes and Y, the whole row to be deleted.
2. If the values in columns in J, K, L and M are 0 (zero)(Match Entire cell contents), the whole row to be deleted.
A code will be easier to find and delete as the data has more than 1000 rows in some cases and the rows fulfilling the 2 conditions are not in an order. They can be in the middle or in between anywhere in the sheet.
The expected result is shown in the workbook. As the data is huge and above the prescribed limit of 3000 cells I am sharing the link to the workbook for your reference.
Loading Google Sheets
I have this sheet B2B where there are some unwanted rows I want to remove. First I need to create, Move and make a copy of B2B sheet and rename the copy sheet to 2B, then I want to delete all the rows if those rows fulfill 2 conditions.
1. In the column H, the rows which contain Yes and Y, the whole row to be deleted.
2. If the values in columns in J, K, L and M are 0 (zero)(Match Entire cell contents), the whole row to be deleted.
A code will be easier to find and delete as the data has more than 1000 rows in some cases and the rows fulfilling the 2 conditions are not in an order. They can be in the middle or in between anywhere in the sheet.
The expected result is shown in the workbook. As the data is huge and above the prescribed limit of 3000 cells I am sharing the link to the workbook for your reference.
Loading Google Sheets