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

 

[AndyJM87]

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?

Apologies, my mistake I referenced the wrong column.

So that has dumped the data. Is there anyway to format it into a readable format.
Is it possible to format into a table, or can you only view it as is? I tried to format as a table and I got #SPILL?

 

[Fluff]

Unfortunately I don't think you can use that type of formula in table.
You can format columns to display the data in a certain way, but that's about it.

 

[AndyJM87]

Ok, Thank you so much. It is way better than what I had before.

You have been an absolute star, I certainly owe you some beers after this lockdown! Thank you so much for your patience.

The more I use Excel and look on this forum the more I learn, There is an absolute wealth of knowledge on here!

 

[Fluff]

You're welcome & thanks for the feedback.

There is an absolute wealth of knowledge on here!

Totally agree, it's where I've gained most of my knowledge.

 

[AndyJM87]

I am going to have to re-open this thread. Is there another way without using =FILTER?

I did this sheet on my own computer with Office 365, turns out my workplace are using Office 2016 which does not support the FILTER function

 

[Fluff]

What column is the SY04AB in ?