Copy and paste with filter

[prinztegame]

Hi everybody, a little help please!!!!!

In Sheet1 I've a table that goes from B5:AB5 down to B44:AB44. How can I copy and paste on Sheet2 the data contained in every row of the table but ONLY if there is something in the cells of column AB? That means, for example, that if cell AB37 is empty, range B37:AB37 must not be copied on Sheet2 and the same should happen to every other range of the table where its cell AB is empty.

Thank you very much in advance,

Max

 

[venkat1926]

autofilter the data (from B5 to AB44(you must have column headings in the first row choose accordingly) criteria being column AB not blank
and you can copy paste the filtered data to any location.

 

[ganeshpoojary05]

before copying the data press Ctrl + ; this will select only the visible cells and then copy and paste your data.

 

[prinztegame]

Thank u very much to everybody!!!