I have a column that consists of hard-coded cells as well as formulas. Based on whether a specific cell is either hard-coded or contains a formula, I want to display it in two separate new columns.
So far that's pretty easy, e.g. using Go to - Special. However I need to maintain the row, and that's where I'm stuck.