Hi friends,

I have searched but cannot seem to find a code that works for me. Excel 2013. Sheet "Master" contains text and values from columns B to J.
I would like VBA code please that will select B7 to last row, then across to column J, then look for values in column J which are "0", then copy only those rows from B to J to sheet "Returned Stock".

All and any help will be greatly appreciated. Thank you kindly.