Mac: Copying row of data that contains dates between two specified dates.

mvdiamond Posts 4 Registration date Sunday September 29, 2019 Status Member Last seen October 3, 2019 - Updated on Oct 3, 2019 at 12:07 PM
Hello Friends,

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.

The help of an expert will make my work easy as I would be able to see looming deadlines in all companies on one sheet.

Thanks in advance for the support and guidance.

System Configuration: Macintosh / Chrome 77.0.3865.90