Cut and paste from one worksheet to another

**jamesstorx** · 03-18-2009, 06:35 PM

I have a list of inventory and I want to paste the rows that contain the word "Buy" to a new worksheet titled "Order". When I run the macro I end up with a 0 in every cell from A6 to IV6. This is what I have so far.

Thanks in advance for any help.

Please Login or Register  to view this content.

**JBeaucaire** · 03-18-2009, 08:38 PM

Use this instead:

Please Login or Register  to view this content.

**jamesstorx** · 03-19-2009, 01:15 PM

That works great but it only Copies & Pastes the first instance of "Buy" and then stops.
I am not sure, but I think I need to loop it some how. Could you help with that?

Thanks again.
-James

**JBeaucaire** · 03-19-2009, 02:55 PM

It is looping through all the valid ranges in column I. On the sheet I had to mockup to test it (you didn't upload a sheet to test on) it works as expected.

Post up your sample sheet, and be sure to try the macro again on the sample sheet just before you upload it.

If it's not really obvious, I suppose it wouldn't hurt to mockup a "results" page too so we can see the goal. It's usually obvious, but sometime not.