Help in dynamically summarizing info with refreshing option

[0kuden]

Hello,


I am looking for your Excel wisdom to help me resolve the below explained problem, having searched and not really identified a specific solution for my issue. I am not sure how much has to be code (for a if..then loop, etc) and how much is Excel formula.




I have a set of data (such as a made up Example A below) on 800 or so rows and has several columns which contain dates, amounts, names and so on. I then have a few rows on the top of the sheet (such as a made up Example B below) dedicated to extracted information from the data set in function of a variable X in one of the columns. This "summary" section (which should end up being about 10 rows) needs to be populated with the oldest entries (ascending order) in the data set where the variable is X, and the list needs to refresh (manually or whichever way) when I change the variable to Y for entries in the data set, therefore removing that entry and populating with new entry for bottom row(s).


Example A:

Date	Name	Color	Amount	Has replied
5-Jun	John	Red	54	No
9-May	Mary	Blue	100	No
11-Dec	Alfie	Red	54	Yes
17-Jul	Ronald	Green	845	Yes
19-Jul	Paul	Red	654	No
10-Nov	Julia	Red	125	Yes
1-Dec	Betty	Purple	5558	No

<colgroup><col width="143" span="5" style="width:107pt"> </colgroup><tbody>
</tbody>

Example B:

Date	Name	Amount
9-May	Mary	100
5-Jun	John	54
19-Jul	Paul	654

<colgroup><col width="143" span="3" style="width:107pt"> </colgroup><tbody>
</tbody>

I am looking for your help in how to setup something of the sort, or where I can start hunting to build something adequate for the job.


Many thanks in advance for your help, and apologies if this does not fit the bill in this section of the forum.


Cheers
0kuden