Hello,

I’m looking for a code that does several things.

In order of operations….

1) Select worksheet (“STRC”)

2) Search column “L” for the first instance of the word/code “STRC00” then assign to a variable (any variable that’s works….I’ll call it “Variable 1”).


3) I then would like the code to search the same column (“L”) and find the first instance of any-word (XXXXXX – 6 digits in length..its a coded prefix) below the word “STRC00” and assign it to a different variable (I’ll call it...Variable 2)


4) Then I would like all the rows (the entirety of the rows..including other columns in the same row) to be deleted from variable 1 all the way down to variable 2…but I don't want variable 2 …or its row deleted.


5) Then I want this code to repeat until there are no more instances of the variable “STRC00” left in column “L”


Can it be done? Any effort is much appreciated!