I am having all sorts of problems trying to figure out VLookup in VBA.
The data I am pulling from is in another workbook entirely. The column I am looking for is determined elsewhere in the module and saved on a working data spreadsheet. The biggest problem is that the VLOOKUP is looking for yesterday's date, then I need to pull data from that row in the given column AND from the next row in the same column.
I have never used VLookup in VBA before, and I'm pretty sure I just have the syntax wrong. The sources I usually use for formatting are of NO help this time.
Also, any suggestions on how to get the value from the next cell down would be appreciated.
Bookmarks