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

S

Skeletor

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
 
M

Max

.. 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
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Rows with a cell value >0 from several worksheets to a new sh 4
Copy Rows with a cell value >0 from several worksheets to a new sh 5
I want to copy rows with values >0 to another worksheet automatica 4
copy rows to another file 0
Copying a Range from Multiple Worksheets 4
copying to new workbook 0
Copy rows to new sheet based on value in column A 0
Need excel copy a row and automatically insert new rows based on a cell contents 0

Top