conditional copy from column to another
Posted on 2014-02-21
I have multiple Excel worksheets in a workbook in which I would like to, for each worksheet, inspect column C for the presence of only a hyphen "-".
If there is only a hyphen present in the cell in Column C, then I want to copy what is in that same row in Column D into Column C.
So, if row 10 of Column C has only a hyphen, then copy the contents of D10 into C10 and continue wherever there is only a hyphen in a cell in Column C.