I have been trying to get my macro to auto fill a vlookup formula from cells E2 to the last row based on how many rows data is the spreadsheet "Data". This number will constantly change.
Here is my coding:
Dim Data As Worksheet
Set Data = ThisWorkbook.Sheets("Data")
Dim LastRowData As Long...