Take Data From 1 sheet to another based on cell value

[dave2017]

Hi,

I have a sheet (sheet1) that has data from column A to column M and row 4 onwards. some rows have a 0 in column M.
I would like all rows that are greater than 0 in column M to copy/filter to my other sheet (sheet2), Is there a formula that I can put in sheet 2 so I only get rows greater than 0 ?

Thanks Dave

 

[Marc L]

Hi,​

​

as your profile does not indicate which Excel version you use neither on which platform …​

 

[dave2017]

Hi,​

​

as your profile does not indicate which Excel version you use neither on which platform …​

Hi Marc,

Apologies ! I am using Excel 2019 home & business on windows 10 pro.

Thanks