How can you selectively copy the active cell.value to another worksheet
only if it was BLANK before you changed its value.("Sheet2").Range("B" & Rows.Count).End(xlUp).Offset(1)
In other words, if the cell had a value in it before you changed it, I dont want to copy it.
Thanks