I want the adjacent cells in Column A and Column B to swap with the underneath cells in Column A and B if the following condition meets:
If Column C > 1 and Column D > 4
Please, keep in mind in columns C and D are formulas based on the text that appears in columns A and B and will change when the cells are swapped. Additionaly, I would like the code to loop until all the cells in ranges A2:B100 meet the following in columns C & D:
Column C > 1 and Column D > 4.