Vlookup loop vba

Hello,

I'm relatively new to using vba. But, basically what I have now is a list of dates in column A on sheet 1. In every seventh column there is another list of dates (i.e. G, M,... etc.). I would like to write something in vba that will pull rates from column B in sheet 2 (for which there are dates in column A), and enter them in sheet 1 two columns to the right of the associated dates (C, I, O,... etc). I know this might sound a bit unclear so please ask me any questions that might clear it up. Thank you.

Can you upload example workbook with your inputs and desired output?

Here's an example of what the file looks like. Unfortunately I don't have the actual file on this computer which will have significantly more data

Here, try this:

Please Login or Register  to view this content.

Sorry for taking so long to get back but is there a way I could alter this to work for dates that don't match up exactly? I'd like it to still pull the data if the dates are witihin three days of each other ideally