Hi There , im really new to macro scripting. I have a word repeated in column 1, called "project:". once identified i need to count down and delete rows as per the following: count down 9 rows from the project row (and check if the column 1 word is "ID kV" if yes, delete that 10 rows (including the row with "project:" count down 11 rows from the project row (and check if the column 1 word is "ID kV" if yes, delete that 12 rows (including the row with "project:" else delete 17 rows (including the row with "project:" this is a 2000+ row sheet and the above conditions multiple times in any order. for now these are the only conditions to watch out for.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Delete certain rows based on a word in column 1. The word is repeated

Thread starter Terencep3
Start date Sep 8, 2022
Tags

count row delete a row

Terencep3

New Member

Sep 8, 2022

Hi There , im really new to macro scripting.
I have a word repeated in column 1, called "project:". once identified i need to count down and delete rows as per the following:

count down 9 rows from the project row (and check if the column 1 word is "ID kV"
- if yes, delete that 10 rows (including the row with "project:"
count down 11 rows from the project row (and check if the column 1 word is "ID kV"
- if yes, delete that 12 rows (including the row with "project:"
else delete 17 rows (including the row with "project:"

this is a 2000+ row sheet and the above conditions multiple times in any order. for now these are the only conditions to watch out for.