Excel advanced filter

Hey Guys,

I need to split the rows of a workbook into separate sheets based on the values in column 3.

So all the rows that are “abc” in column 3 into a sheet called Records_abc etc.
I found this post by mikerickson but it only copies the first four column in a row and I dont know the syntax well enough to adapt.


Help Please