Macro to copy paste data to other sheet without zero value

Dear all,

I would like to copy then paste to another sheet (sheet "Done") with same format without Zero (0) value but include negative (-) value in column G.

Please help, thank you before.

Regards

Make a Command Button on your sheet
And add this macro

Please Login or Register  to view this content.

Dear AmirSoft

Thank you for your kind help, but when i run the macro it error "Variable not defined" with debug highlight in "MY_ROWS_1"

Hello,

Run the procedure CopyFilteredData

Please Login or Register  to view this content.

Thanks