Macro which copy cells if other cell have specific value

[alicjon]

Hi guys,

I need help with macro
I need macro, that will be copy value from cells in column B from sheet1 to first avaible (free) cell in column D of sheet2 under condition that in cell in column F of sheet1 (in that row) is value "yes". After that i need to remove that row in sheet1. I have something like this at this moment:

Please Login or Register  to view this content.

I hope you can help me.
Please!

[Mumps1]

Whenever you delete rows, you should start at the bottom of your data and work your way up. The macro should do what you want but because it starts at the bottom in Sheet1, the values in column D of Sheet2 will be copied in reverse order. If this doesn't matter, then it should work for you.

Please Login or Register  to view this content.

[Thalassa]

Cross posted http://www.mrexcel.com/forum/excel-q...condition.html