Greetings,
I am an advanced excel user with 8+ years experience.
I will be able to create the excel file you require once I have been provided with the raw data for the same.
My result will include a comprehensive All-in-One file designed using VBA, macros and formulas.
You will get the functionality of Pivots and an option for search by date. Additional functionality can be included as per the requirement
Kindly reach out to discuss further details