select only non null records that are of a specific range (all records have 6 cells)

How do i select and copy entire row from sheet2 that have no nulls at all and paste them in a sheet3?

try working with

Please Login or Register  to view this content.

How do I run this code??

Is there a function that can do this or a formula?

Thanks for your help Kebec_ska

Are you directly in Excel or using Visual Basic? Thats VB codes...

If you are in excel and you dont want to start writing a macro in VB, you can simply insert row a the top of your range, select the desired range width within that row, go in the "Data" tab click on "Filter" and then just by unchecking "Blanks" in each created filter and select what remains and paste it in your new sheet... If you want to do that automaticly, VB... no other way.. And thats longer to explain..

dont forget to hit the lil star in the left corner to add me reputation if you find that usefull