VBA to copy row

[juriemagic]

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.

[Richard Buttrey]

A copy of the workbook would be useful, but in the absence of one here's what I'd do

Please Login or Register  to view this content.

[juriemagic]

Good morning Richard,

Your code does exactly as I expected it would!..Thank you very much...May I press your button just one more time please?...How can I reverse the formatting/Sorting on the Master sheet?. This sheet needs to stay unaltered..Thank you again..

[juriemagic]

Hi Richard,

No worries I found solution for that on the web. Thank you once again!!