Hi,
I like to write a macro which will search for a specific word from the following worksheet and store it into an array for a certain condition.
my worksheet looks like(in pict)
The search will start from the 2nd row and will looks for a word "Begin", when the search successfully found the word "Begin" it will store the words from the third token e.g "20kv" (in the above worksheet), it will continue as long as it will find the word "End" two times simalteneously (cell 24,25 in the above worksheet). Then it will store the array content "20kv UW 10kV E3 Allgemein QuittSammelst