Hi,

Can some one help me, please?

I am working with two worksheets - one a Summary Page which is a Pivot Table
and the other the data page which contains the information for the pivot
table.

In one of the fields in the Summary page, I would like to transfer the total
of all items that have a value greater than today's date. I need the system
to identify all transactions that are dated greater than today and then pick
out the repsective amounts for each of this rows, add them up and populate
back into the Summary page.

Thanks and regards,
Nithya