Check if date already in a column

[z0de]

Hi all,

I want to check if a user imputed date is already in a column before copying it across.

Sheet1: Input sheet with date in cell B2
sheet2: table of data with dates in column A

what I think I want:
If sheet1 b2 is in column sheet2 column A
then stop.


Any help would be good.

 

[Andrew Poulsom]

Is this in VBA?

If WorksheetFunction.CountIf(Worksheets("Sheet2").Columns("A"), Worksheets("Sheet1").Range("B2").Value) Then

 

[z0de]

it is vba, that code gives a subscript error.

outside of vba I got countif to work with:

=COUNTIF('Daily Data'!A:A,Input!B2)

Daily data is sheet5, Input is sheet1.

What I tried:

If WorksheetFunction.CountIf(Worksheets("Sheet5").Columns("A"), Worksheets("Sheet1").Range("B2").Value) Then

 

[Andrew Poulsom]

You said that your sheets were nemaed Sheet1 and Sheet2. Try:

If WorksheetFunction.CountIf(Worksheets("Daily Data").Columns("A"), Worksheets("Input").Range("B2").Value) Then

 

[z0de]

Sorry about that, the new code works great thanks.