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



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?



0 Replies