Sorry, I have zero knowledge or skill with VBA! Sometimes I can manage to cobble together what I need in a macro, but this time I'm stumped... it should be extremely simple, but I just don't know the syntax well enough.
Here's what I need to do:
Part 1
1. Search for the value "99" only in column A
2. Whenever a value is located, delete that row AND the next 5 rows.
3. Search for the next occurrence of "99" and repeat until end of column A
Part 2
1. Search for the value "developing" in column C
2. If found, check if the value "integrating" appears in the cell beneath
3. If "integrating" does not appear then [code X]
4. If "integrating" does appear then [code Y]
5. Search for next occurrence of "developing" and repeat until end of column C
Part 1 is a higher priority, as I think I can figure out Part 2 on my own with enough time.
Thanks in advance!
Bookmarks