In an Excel Worksheet I have several thousand records. The value of Column B always contains a string which can be from 2 letters to perhaps up to 10 letters long.
I need help with VBA macro which will delete all rows (records) in this Excel Worksheet where the value of the string present in Column B start with the letters ”tka”. When a row is deleted all the rows below it should move upwards. The number of records in this Worksheet keeps changing so at the start the Macro will need to calculate how many records we have in the Worksheet and then loop accordingly.
So if there are four records in the Worksheet with the value in Column B as below
After the macro runs we will be left with three records in our sheet.