Hi. Im a bit stuck on how to attack this problem in vba and im sure someone has a basic solution for this:
In Sheet1, I have A1: Start Date and A2: End Date
In Sheet2, is the look up sheet. Its sorted by ColumnA:
ColumnA.......ColumnB.....ColumnC...ColumnD...