GO TO THE LAST DATA BASED ON 2 CELL DATA

[wndncg]

I have a working code just for 1 data but i need based on 2 data. ty mrexcel.

Dim Rng As Range
Set Rng = Range("A" & Rows.Count).End(xlUp).Offset(1)
Set wsCellVal = Sheets("TEMPLATE")
Set wsFIN = Sheets("FIN")
cv = wsCellVal.Range("E1")
Columns("A").Find(cv, After:=Rng, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False, _
SearchFormat:=False).Select
Application.Wait (Now + TimeValue("00:00:01"))
'wsFIN.Activate
'Call INSERT_ROW_SPECIFIC
'ActiveCell.EntireRow.Insert

 

[cmowla]

This is a wild guess. Is this what you want to do?

Sub Find_Cell_In_Column_A_Of_Active_Sheet_That_Matches_Value_E1_Of_Sheet_TEMPLATE()

Dim rng As Range
Set rng = Cells(Rows.Count, "A").End(xlUp)

Range("A:A").Find( _
    Sheets("TEMPLATE").Range("E1").Value, After:=rng, _
    SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _
    MatchCase:=False, SearchFormat:=False).Select

End Sub

 

[wndncg]

This is a wild guess. Is this what you want to do?

Sub Find_Cell_In_Column_A_Of_Active_Sheet_That_Matches_Value_E1_Of_Sheet_TEMPLATE()

Dim rng As Range
Set rng = Cells(Rows.Count, "A").End(xlUp)

Range("A:A").Find( _
    Sheets("TEMPLATE").Range("E1").Value, After:=rng, _
    SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _
    MatchCase:=False, SearchFormat:=False).Select

End Sub

yes but based on a value on A1 and E1

 

[cmowla]

yes but based on a value on A1 and E1

I would assume that A1 and E1 are both from Sheet TEMPLATE, correct? And if so, it is to search for both the value of A1 and E1 (from Sheet TEMPLATE) such that, if when it searches for, say, A1's value but doesn't find it in Column A of the active sheet . . . that it will then repeat the process but search instead for E1's value (from Sheet TEMPLATE)?

 

[wndncg]

I would assume that A1 and E1 are both from Sheet TEMPLATE, correct? And if so, it is to search for both the value of A1 and E1 (from Sheet TEMPLATE) such that, if when it searches for, say, A1's value but doesn't find it in Column A of the active sheet . . . that it will then repeat the process but search instead for E1's value (from Sheet TEMPLATE)?

Here's an image:

I need a macro that:
It will go the last data (date on column A) on conditions (if data on A1 matches on date in E1)
-example if in E1 is 02/01/2022 it will go to the row 13 because it is the last data.

 

[cmowla]

Here's an image:

I need a macro that:
It will go the last data (date on column A) on conditions (if data on A1 matches on date in E1)
-example if in E1 is 02/01/2022 it will go to the row 13 because it is the last data.

So all of this is in the same sheet then. (The sheet you are looking at is Sheet TEMPLATE.) Okay, what happens if the dates in A1 and E1 don't match? What should it do? Nothing?

 

[wndncg]

So all of this is in the same sheet then. (The sheet you are looking at is Sheet TEMPLATE.) Okay, what happens if the dates in A1 and E1 don't match? What should it do? Nothing?

yes nothing sir.
yes sheet TEMPLATE

 

[cmowla]

Okay, just one more thing before I continue attempting coding. It appears that the number formatting of A1 is not set to date like the others. I just wanted to let you know that. That will pose a problem with this comparison! (Please fix that.)

 

[cmowla]

Wait, you want to have the last date possible in column A that matches E1 whose value in the same row in Column B matches the value in A1?

 

[wndncg]

Okay, just one more thing before I continue attempting coding. It appears that the number formatting of A1 is not set to date like the others. I just wanted to let you know that. That will pose a problem with this comparison! (Please fix that.)

what format should i use sir? its currently mm/dd/yyyy