I need to create a report (from multiple workbooks) of activities that are to
occur "today" from a list of dates (Column A)and events (Column B). but the
dates might not be in ascending order and some cells in Column A may not
contain a date. There is one such "table" in each workbook. The report
would look like this:
Today's Date
Workbook1 Empty trash
Workbook2 (blank) because there is nothing to be done today
Workbook3 Cook dinner
Is this possible?
Bookmarks