Hello!
I need some code that will do the following:
Find all rows that contain the field names, in this order:
"Oid", "Parent.Name", "LastVersion", "Ideas", "Scope", "Timebox.Name"
Oid is in column A
Parent.Name is in Column B
LastVersion is in Column C
Ideas is in Column D
Scope is in Column E
Timebox.Name is in Column F
Once all rows have been identified, delete this row as well as the two rows that are above the field names.
So if the VBA code has identified row 1000 that contains these field names, delete rows 1000, 999, 998.
There will be around 40 times that these field names will be present and all 3 rows need to be deleted. So if these field names show up in 40 seperate rows independently, then there should be 120 rows that get deleted.
Please let me know if you have any questions. Thank you so much!
Bookmarks