Returning all rows from table that match certain criteria

I need to retrieve information from multiple rows in a table based on certain criteria (date compared to today's date, existence of "no" in a column).

Problem and solution I would like attached. Many thanks.

Your sheet indicates you want this to be going on "automatically", so I would think a macro would be the way to go. Is VBA ok?

Here are two versions of a macro that will do what you want based on moving that data back up to A1 as the starting point, like normal.

Please Login or Register  to view this content.

This macro goes into the sheet module itself, so just by bringing the sheet up onscreen, the Overdue report updates itself.
How to install the sheet macro:

1. Open up your workbook
2. Right-click on the OVERDUE sheet tab and select View Code
3. Copy and Paste in your code (given above)
4. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Simply move to another sheet, then return to the OVERDUE sheet and it will update.

==========

Please Login or Register  to view this content.

This version is a standalone macro that goes in a regular module and can be run from the macro menus. How to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

Yes it can. In fact I'm glad you asked. I didn't look at your "desired results" section very carefully, did I? Sorry about that...the index/match technique is actually well suited to this task.

I added a "key column" to the data sheet so that it can flag the overdue items in an easy sequential way. You can hide that column if you find it unsightly.

On the OverDue page, we then index/match those key rows into the table and do the required math on the last column.

You didn't mention you had other sheet-level macros active on that sheet. Yes, the macros would interfere with each other unless you specifically tell the active macro to suppress others.

To do that, you add these lines of code to the top and bottom of the macro:

Please Login or Register  to view this content.

Using that, your macros will always trigger independently and execute quickly.