Thread: Default column value

try:

=IF(COUNTA(A2:I2)>0,"x","")

Only thing I can think of is to make a macro for it, it should work regardless if the column is hidden or not. but J1 (or change the "J1" to "J2" in the macro code) needs to have the formula:

=IF(COUNTA(A1:I1)>0,"x","")

The macro will copy J1, paste down the column, then remove any excess empty cells at the bottom of column J. You will need to run it everytime you insert a new row, or after you insert all your new rows.

I know you were looking for something more automatic, you may just need to make a note to remind you to do it. Best of luck.

Marco code below:

Sub x_into_Jcol()
'
' x_into_Jcol Macro
'

'
    Range("J1").Select
    Selection.Copy
    Columns("J:J").Select
    ActiveSheet.Paste
    Selection.End(xlDown).Select
    ActiveCell.Offset(0, -1).Range("A1").Select
    Selection.End(xlUp).Select
    ActiveCell.Offset(1, 1).Range("A1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.ClearContents
End Sub