VBA Excel copy the entire row where the specific column is not empty.

[lhm7877]

id model color quantity price
1 a black 3 300
2 b red
3 c blue 2 400
I'd like to copy the entire row where the 'quantity' column is not empty. And I'd like to put it in a specific column.

id quantity price
1 3 300
3 2 400

 

[Fowmy]

Hi,

VBA solution is possible but you can easily filter the data table by Quatitiy <> Blank, copy and paste on to a new sheet and remove unnecessary columns.

Thanks
Fowmy

 

[Michael M]

Where do you want to paste the copied rows ?

 

[lhm7877]

Where do you want to paste the copied rows ?

ThisActiveWorkbook.Worksheets(1)
thank you

 

[Michael M]

Ok, but where....you said...

And I'd like to put it in a specific column.

Do you mean row with this statement ?
If you copy an entire row....it, by default gos in col "A"