Copy entire rows of data from a raw dump depending on value in a cell

[AndyJM87]

Hi all, I hope someone can help me.

I have a data sheet called "RAW" with numerous columns.

I want to be able to search through the RAW data set, pull out all rows which match a specific value in a cell.

So, column "D" in RAW contains a VRN (they are not all ordered as per my screenshot), and I want to search the RAW data based on the VRN (Column "D")

I have a sheet named "AB001AB. I want to copy all rows with the VRN "AB001AB" into the sheet "AB001AB". Then all rows with the VRN "AB002AB into the sheet "AB002AB"

Any help much appreciated. I can imagine this being quite a lengthy formula.

Thanks

 

[Fluff]

Do you have the dynamic array functions?
If not would a macro be ok?

 

[AndyJM87]

Do you have the dynamic array functions?
If not would a macro be ok?

Excel 360 the most recent, so I assume so. But I have never used these functions/

 

[Fluff]

If you type
=SEQ into a cell does it give you the option of Sequence?

 

[AndyJM87]

If you type
=SEQ into a cell does it give you the option of Sequence?

Yes it does

 

[Fluff]

Ok in A2 put
=FILTER(Raw!A2:K1000,Raw!D2:D1000="AB001AB","No data")

 

[AndyJM87]

That just gave me #NAME?

I replaced AB001AB with SY04AB

 

[Fluff]

You've got an equals sign between D=1000, it should just be D1000=

 

[AndyJM87]

Well spotted. But I now have "No Data". I changed it to 100000 as I have almost 14,000 rows of data.

You guys have so much patience lol. My work laptop is close to being thrown up the garden.

 

[Fluff]

In that case it can't find anything in column D with SY04AB.
Check that there are no leading/trailing spaces in col D on the Raw sheet. Also should it be a zero or the letter O?