Advanced Filter

[adam]

Your formula is incomplete. Please compare it to the complete formula in your previous reply.

Hans if you don't mind, non of the following formulas is NOT working according to me. What am I doing wrong here?

=OFFSET('Select Movies'!$C$5,0,0,COUNTA ('Select Movies'!$J:$J)+4
=OFFSET('Select Movies'!$C$9,0,0,COUNTA ('Select Movies'!$J:$J)+4
=OFFSET('Select Movies'!$C$9,0,0,COUNTA('Select Movies'!$J:$J),8) +4
=OFFSET('Select Movies'!$C$5,0,0,COUNTA('Select Movies'!$J:$J),8) +4

[HansV]

None of those make sense. Please go back to the formula that worked, then read my replies again.

[adam]

Nevermind Hans. I've somehow solved it. Thanks for the help.

[adam]

The following lines currently add both date & time to column "C". How could I make it to add date to column "C" and time to column "D"?

Code: Select all

Static runme As Boolean
If runme = False And Target.Column = 4 And Target.Row >= 11 Then
    runme = True
    Target.Offset(, -1).Value = Now()
Else: runme = False
End If

Any help on this would be kindly appreciated.

[HansV]

Target.Offset(, -1).Value = Date
Target.Value = Time

[adam]

Thanks for the help Hans.