Copy Rows with a cell value 0 from several worksheets to a new sh
 

Max and Mike H,

The code you gave me worked perfectly....... on Friday.

On Monday, for some reason, when I clicked in the "Quantity" column on any
item on a sheet, it would copy Row #9 across to the new sheet. As I clicked
other items, it would the copy Row #10, 11,12, etc.Why is this happening? I
rechecked the code and nothing has changed. I deleted the code, re-wrote it
and the same thing happened. What have I done to muck this up?
Thankyou
Mike W

Copy Rows with a cell value 0 from several worksheets to a new sh
 

.. rechecked the code and nothing has changed.
You never know. Suggest that you do a copy n paste of the exact code that's
in your book (from the ThisWorkbook module). Then maybe somebody here can
help you to eyeball it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---