get value the lastrow from sheet to another

[MKLAQ]

hi
i have data in two columns a,b the col a is date and b the values I would bring the value for last row based on date (today) and copy to cells f5 in sheet2
this is what I got so far

Sub vv()
Dim rows As String
Dim value As String
Dim concat As String

rows = Range("b1048576").End(xlUp).Row

Dim a As String
'Column
b = "b"
concat = a & rows
'Value in last low is below
value = Range(concat).value

MsgBox (value)
End Sub

 

[Joe4]

You are welcome.
No worries! I see that you are fairly new here, and it often takes time for people to learn how to post good, complete questions.
I think one of the most useful things is to post examples of different scenarios, and telling us what they expected results are in each case.
Especially if English is not your primary language, pictures can often say a lot and really help show us what you are after.