If I have a sheet (Sheet1) with 3 columns (A, B and C) with data from row 2 to 100, where: columns A and B have text and column C has TRUE/FALSE.
I would like to have a macro to copy the text of column A (if True) or B (if False) to column D.
Note that I cannot reference cells as same text is strikethrough. Basically an if function would solve if the text was not strikethrough!
Would really appreciate an help on this.