Mark F
Well-known Member
- Joined
- Jun 7, 2002
- Messages
- 513
- Office Version
- 365
- Platform
- Windows
Hi
I have to do job weekly on a sheet with random number of rows ie one week 300 next week 10000
In column B, the word "product" appear regularly perhaps 30 times
I want to select the first row with the word "product" in it, then select the subsequent rows until the word "product" appears again in column B, then delete the selected rows (including that second row with "product")
I need to then find the next row with "product" in column B and repeat the process
I need to repeat this for all rows in the sheet
I have tried to find a solution on the forum but without musch success
Thanks for any help
Mark
I have to do job weekly on a sheet with random number of rows ie one week 300 next week 10000
In column B, the word "product" appear regularly perhaps 30 times
I want to select the first row with the word "product" in it, then select the subsequent rows until the word "product" appears again in column B, then delete the selected rows (including that second row with "product")
I need to then find the next row with "product" in column B and repeat the process
I need to repeat this for all rows in the sheet
I have tried to find a solution on the forum but without musch success
Thanks for any help
Mark