VBA Code anomaly

Hello everyone,
I hope I could get some help here with my vba code below:

Please Login or Register  to view this content.

For any reason unknown to me above code fails to return the desired filter from the table.
The code is supposed to loop through the "MomentumDescription" column and fetch only the "New Wave Positive" elements that are between any two "SQ Cancelled" element in that column within a specified timeframe in cell E5 from the "Timeframe" column in a worksheet named "Trend Analysis". The "SQ Cancelled" is the boundary that marks a cycle (LV). The code is supposed to exit after the first five cycles and write out the output in a new worksheet named "OutputData". But the output of the code only return just one of the "New Wave Positive" element in each cycle together with other elements that are not needed from the dataset.

Can someone please help me out with the logic to only fetch the total occurrences of "New Wave Positive" Element within the specified timeframe that is between every "SQ Cancelled" element. I also need the last "SQ Cancelled" element to be fetched together with the "New Wave Positive" elements per cycle.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

As you are new to this forum, I have added the code tags for you today. Please take a few minutes to read our guidelines and rules and comply in the future

see big yellow banner - how to upload your workbook - far easier then to give you a tested solution.