Populating Table From Other Tables Based on Criteria

[chrismo16]

Hello all,

I am not sure if this would be a formula or pivot table question so posting it here and am happy to move it, if necessary.

I want to populate a table with data from tables on other sheets based on a criteria.

For example on the attached file:

I want to populate rows in the Payment_Status table (or a pivot table if that is the solution) with information in the tables on the other sheets (AT_T_Mobility for example) if the "Est. Date" is past due.

Any suggestions?

Thank you,
Chris

[vba_php]

you can use a few VBA methods. I always use the range object. but I know there are other ways easier, that are used by the professionals. also, see the attached image. your file, for me, shows an error for improper formatting for the month names on the sheet AT_T_Mobility. in VBA, there are many date functions. you could make use of DATE(), MONTH() AND DATEDIFF().