Need to check if two cells=5 then copy information into next row on different sheet.

Hi Guys,

I'm struggling a bit too much than I'd like to admit on this.
I have 21 Sheets and need to check sheets 3, 12, 17
If C2 and D2 both equal 5 then copy entire row into sheet 21 in next available row.
And i need this to repeat down to C250 and D250.

Thanks.

Start with

Please Login or Register  to view this content.

Unfortunately nothing with this. If the values were from an excel IF function, would this affect the outcome?
For full clarity the sheets were orignally named.
3 - Brett
12 - Matt
17 - Tony
I did change these to work with array but no luck.

Thanks, second one seems to be working better than the first with my other formulas. I should've been more specific originally. I meant, if C=5 and D=5 then copy. Thats my fault. I've swapped 5 to 10 on your code, same thing and its working almost perfectly. I just have to figure out why some come through with #REF! and it's complete.
Thanks a lot for your help.

Please Login or Register  to view this content.

Updated.
Still having some issues with the reference. It seems that when it copies the code over, the IF statements are starting at I1 again.
e.g. =IF(September!$I1=1309,September!D1,"") on row 5 so this should be =IF(September!$I5=1309,September!D1,"")
This pulls through no info as the I1 check should be I1=153.

I think it would be easier to change to collecting data from the September tab and thats it and i can filter again after the fact.
What do i need to change if im just going to look for data in the one sheet?

Thanks again.

Damn mate, you're a genius.

Thanks bro, exactly what i needed.

Glad to help. Thanks for marking as solved