copy paste, cells of 2 other columns of the same row, that contains certain text of another column

Brass Contributor

 

Hello, i can t find a way for this

 

Is this possible in VBA :

 

In Sheet1 i have data. If in Column L, cells contain "Yes",

then Copy ONLY cells from Column B and Column D of the SAME ROW

and Paste to Sheet2 in Column A and Column C to Last Row?

 

Please.

0 Replies