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
Bookmarks