Copy a range in a row to a new sheet if cell value in a column is greater than zero

Hi All,

New to the forum and I would like to break the ice by asking how to copy a range of cells in a row on to another sheet if cell value in a column is greater than zero. I've attached a copy of a sample spreadsheet of what I am trying to achieve in this project.

I will basically have a huge list of inventory in sheet 1 and I will need only the rows that have values greater than zero from column D to be copied over to Sheet 2 next available line.

It would be nice if I could just a formula rather than using a code.

Any help or suggestions would be greatly appreciated.


Thanks!

SampleCopy.xlsx

Thanks Andy, but I need it to copy the cells not transfer.

Thanks, but can you also change the code to transfer >0 quantity. It's currently transferring values of =0 quantity.

Andy thanks. Everything is working great! Would it also be possible to transfer only "new" values and not to copy the same values if I do multiple transfers.

How do I refresh the list on sheet 1?

Actually it might be a better option if am able to delete the items on sheet 2 and for the deleted items to automatically return in sheet 1. Once it returns to sheet 1, I also hope to be able to re-enter the quantities and transfer the values again in sheet 2. I think we are almost there... I really appreciate your help.