Copy cells from one sheet to another

purkeenjee 

=IF(ROW(Tabelle1!1:1)>COUNTIF(Tabelle1!$B$2:$B$20;">0");"";INDEX(Tabelle1!A:A;SMALL(IF(Tabelle1!$B$2:$B$20>0;ROW(Tabelle1!$2:$20));ROW(A1))))

Caution, matrix formula included!
The curly braces {} are not entered.
Exit the cell editor with Ctrl + Shift + Enter instead of Enter alone.

array examble

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.