Sihem:
It is not just a formula. You need also to control the location of the data
that you are passing to the Summary sheet.

Argy


"Sihem" wrote:

I need to export data from a worksheet to another one that is the summary
worksheet. To put you in the context, i have worksheets that represent
interest schedules on diffrent loans, and a summary worksheet. I would like
the summary worksheet to be dynamic and show the next interest payment on the
schedule.

Do you know a formula that would help me to do this?

Thank's