Filter out a specific area of ​​an Excel

[Rayyl]

Hello,

I have an Excel (see attachment) and would like to filter out a specific area (area test field 2 - (DE123456789) / rows 8 - 27).

My problem here: The rows vary from week to week and test field 2 could be contained in lines 20 - 35 in week 2, for example.
The only thing that remains the same is the name of the respective row "Test field X...".

Do you have any solutions on how to solve this problem? I only need it for the test field 2 area though. Thanks in advance!

Best regards
Christian

[binuacs]

@Rayyl One way of doing this

[gawa · Accepted solution]

Hi @Rayyl 

Using multi-row formula can help; once detect data starting from"Detail:..." then add its number.

Also, for your convenience, I configured batch macro to combine  all of data. Please reference to attached yxzp WF. 

Output look like this(excluded 2nd one)

[Rayyl]

Thank you guys!!!