I want to copy some selected rows to another sheet.
I.E. Starting with cell AP1 and going down with CTRL+SHIFT+down arrow until he finds the next "X". And then select all these rows, and copy to sheet2.
What I have right now is (But it's not working):