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
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
VBA Code:
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