Advanced Filter - Blank Rows

Advanced Filter Problem

I am using some VBA code that is using the Advanced Filter…

I have now been changing a few parts around the sheet, which is now the master sheet has a row that is blank separating the data.

When I run the macro it creates a Temp sheet where all the unique fields go into so it can sort all the data out.

The problem is that in the Temp sheet it leaves a space between the first work centre and the second one all the others are fine.

See the Example spreadsheet, this is the point where it fails … I am trying to run the Macro “SortDataIdvWC”

Any help with this would be great…

Many Thanks in advance…

Sort of red that on different websites, was looking for solid confirmation...

Thank You...

I'm not a super excel expert, however I was wondering if this may help -
before creating the filter select all cells in the sheet and then create the filter. Not sure if this will help in your situation - let me know.

Hello people!
Can anyone help me in this issue?
This is the script (bellow) obtained with macrorecorder and the problem is that I want the results of the advanced filter applied in the workbook "center" to be copied to another workbook (where from I started the recorder in fact)
The macro cannot be ran if the "center" is not open.


Workbooks("center.xls").Sheets("base CC").Columns("A:S"). _
AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Workbooks( _
"center.xls").Sheets("criteria").Range("A1:S2"), CopyToRange:= _
Range("A5:S5"), Unique:=False
End Sub