| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
| Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
| Copy rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
| how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
| macro to copy multiple rows to separate worksheets | Excel Worksheet Functions | |||
Linear Mode
