Hi, i have a sheet in which i want to find all occurrences of a string suppose "MSC6", later i want to find another string suppose "Fault" within the range of "MSC6",ie its first and last occurrece.(PS. MSC6 not necessarily be isolated, ie the string might be "sdgsgMSC6dfsdff", this should also be considered).
also if you could let me know how to copy all the data between the first occurrence and the last occurrence + 5 lines of "MSC6" . Thanks
Bookmarks