The attached worksheet has some code that was built and works 90% correct. There is one thing that it doesn't do and I cannot figure it out. The data is not updating correctly for the date. On the "Compiled Job Data-After" sheet, cell B1 has the date. It is currently set at 11/12/18 for testing but will actually contain the =Today() formula so it will update daily when I click the button. After clicking the button, the macro is supposed to look across the "Current" sheet range D24:DA27 but it only populates all the desired for all the jobs and doesn't update the data to show only the applicable data for the date reference in cell B1. Can anyone help?
Thanks. [ATTACH]n1212410[/ATTACH]