Split Worksheet

[Brentsa]

Good day,

I have a large worksheet and this worksheet changes day by day. In column A of "Difference Report (Historic): I have a list of names and the word: Inner Seal appears twice. Once in row 6 and then the second time it is random as it depends on the data in the worksheet. Worksheet has data from A:V

I would like to know if there is a formula that I can use to filter the first lot of data under Inner Seal to a Diff worksheet and the second lot of data under the second Inner Seal to Aggregate Diff Sheet.

 

[Fluff]

How about

=FILTER('Sheet 1'!A7:V10000,(ROW('Sheet 1'!A7:A10000)-ROW('Sheet 1'!A6)+1)<=XMATCH("Inner Seal",'Sheet 1'!A7:A10000,0))

and

=FILTER('Sheet 1'!A7:V10000,((ROW('Sheet 1'!A7:A10000)-ROW('Sheet 1'!A6)+1)>XMATCH("Inner Seal",'Sheet 1'!A7:A10000,0)+1)*('Sheet 1'!A7:A10000<>""))

 

[Brentsa]

Once again thanks a million. It works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.