Help needed with VBA to iterate through a worksheet

[Br4c4r4]

I am trying to make a macro that will check an export and copy certain cells if specific requirements are met.

In a nutshell, I want to iterate through the cells in column P. If Px=0, then go on to cell P(x+1) and check the value. When Px=1 then I need to iterate through column N to find N(x+y)=1. Once this condition is met I want to copy the range Ax:I(x+y) to another sheet within the same workbook.

After copying I want the iteration to go on, checking the conditions every time and copying when necessary, until it reaches the end. Every time it copies to the next sheet, I would like the copy to be underneath the previous copy.

My question is, can this be done with VBA? I haven't touched VBA in decades, and so am quite rusty. I'm not asking that anyone solve this, but rather that they point me in the right direction. Which VBA functions should I considering using, etc.?