I am reasonably good at excel but have never used macros or VBA. I have multiple workbooks one for each company which has similarly-formatted worksheets containing different types of information mainly reporting deadlines and process deadlines. As these deadlines are for multiple reporting, the dates are in many columns.
I am trying to create a Master Workbook that can display all the events to be complied with in the next four days. The dates are mainly in two worksheets named 'Process' and 'Reporting'
The link to the template workbook is as under. Such workbooks have been created for many companies.