hey all im using google excel i had a mate help me do some work and i delete something by accident, and not sure what i done, so this is what i got.
im trying to pull data from the last row on the sheet and just keep pulling the data as its added, this is the bit i have messed up.

in cell sheet1 b2 i got this =FILTER('Sheet2'!$B$1:J,{deleted something here}:{and here}:C<>"")

in cell b3 onwards i have =CONTINUE(B2, 1, 2) =CONTINUE(B2, 1, 3) =CONTINUE(B2, 1, 4) and so on, maybe this makes sense to someone i don't know how to use filter.

thanks