So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in Columns A and B based on whether there is an S in the corresponding cell in Column C. I am no expert in VB, but I have these two macros that I am trying to re-work.