I have a sheets that look likes this

a b c d e f
1 jimm 123 3434 342 22 sum
2 john 454 sum
3 james
4 jenifer 4554
5 jimmy
6 george 4344 4334
7 jenny
8 felix 5455

some of the names hasn't values in column a,b,c,d,e like jimmy for example.
In column f i have a sum of (b,c,d,e) values


In other words i want to copy only the range that have some values in
columns b,c,d,e
and paste them in an other sheet one under the other.

I have manage to do that by creating a loop from row 1 to row .... and
checking if f1,f2... etc 0 then copy range from 1 to 5 to another sheet.

I want to know if there is a more simple method for doing this.

I want to use this macro to a balance sheet in order to tranfer to another
sheet only the lines that has values but the thing is that i want to paste
also the formation of the cells, couse some of them has borders that i want
to keep to the other sheet.