Moving Entire Rows

[ohaganli]

okay so I have this code:

Please Login or Register  to view this content.

This code looks at the first cell in a row, and if it contains "Call", it moves the word "Call" to anothr worsheet, then it moves to the next cell down and does the same thing. I need code that will check if the cell says "Call", but instead of just moving the word, it moves the entire row. Any ideas?

[Norie]

You can try this but I think it might be slow.

Please Login or Register  to view this content.

This might be better.

Please Login or Register  to view this content.

What might be better than either of these is to only copy the columns with data.

Please Login or Register  to view this content.

[AB33]

Change this line

Please Login or Register  to view this content.

in to

Please Login or Register  to view this content.

[ohaganli]

Im not quite sure what you mean, Norie. Could you rewrite my code with you adjustments so i can see the entire thing?

[Norie]

All you need to do is replace the line that's putting Call on the other sheet.

Here's the code with the first suggestion in it.

Please Login or Register  to view this content.

[ohaganli]

Works :D thanks a lot