Excel 2007 : Advanced filter issue

[Nikeyg]

Hi guys. Got a problem that's really doing my brain in.

I have a rec that compares two sets of data. It checks to see if account numbers match, and then to see if the balances from both sets of data for that account match.
Data compiles correctly, and reports whether they match or not.

In Cell X1 I have the header 'Account Check'
Cell X2 has the formula ="=NO MATCH"
Cell Y1 has the header 'Cash Check', Y3 has the criteria <>0
Cell X6 also has the header 'Account Check' Underneath is a formula that checks the account numbers in R and D and gives 'MATCH' if they match and 'NO MATCH' if they don't
Cell Y6 has the header 'Cash Check' and underneath has a formula that minus the figures in column S from those in column G.

So, Cells X1 to Y3 are my matching criteria for my Advanced Filter. However, considering I have 69 lines of data under X6 and Y6 whenever I try to apply the advanced filter it tells me that:
'This command requires at least two rows of source data. You cannot use the command on a selection in only one row. Try the following.......etc'
Of course, I have more than one row of data, and more than one row in my criteria. I cannot understand why I am getting this problem.

Can anyone point out where I am going wrong with this?

[Nikeyg]

And the minute I ask, it hits me and I figure it out.

Thanks to anyone who read this, but it is now solved.

[aarabhihr]

I am real glad you figured out the solution... But, could you please share it here? I am in desperate need of the answer...