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:


[TABLE="width: 715"]
<colgroup><col width="143" span="5" style="width:107pt"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 143"]Date[/TD]
[TD="class: xl67, width: 143"]Name[/TD]
[TD="class: xl67, width: 143"]Color[/TD]
[TD="class: xl67, width: 143"]Amount[/TD]
[TD="class: xl67, width: 143"]Has replied[/TD]
[/TR]
[TR]
[TD="class: xl66"]5-Jun[/TD]
[TD="class: xl65"]John[/TD]
[TD="class: xl65"]Red[/TD]
[TD="class: xl65"]54[/TD]
[TD="class: xl65"]No[/TD]
[/TR]
[TR]
[TD="class: xl66"]9-May[/TD]
[TD="class: xl65"]Mary[/TD]
[TD="class: xl65"]Blue[/TD]
[TD="class: xl65"]100[/TD]
[TD="class: xl65"]No[/TD]
[/TR]
[TR]
[TD="class: xl66"]11-Dec[/TD]
[TD="class: xl65"]Alfie[/TD]
[TD="class: xl65"]Red[/TD]
[TD="class: xl65"]54[/TD]
[TD="class: xl65"]Yes[/TD]
[/TR]
[TR]
[TD="class: xl66"]17-Jul[/TD]
[TD="class: xl65"]Ronald[/TD]
[TD="class: xl65"]Green[/TD]
[TD="class: xl65"]845[/TD]
[TD="class: xl65"]Yes[/TD]
[/TR]
[TR]
[TD="class: xl66"]19-Jul[/TD]
[TD="class: xl65"]Paul[/TD]
[TD="class: xl65"]Red[/TD]
[TD="class: xl65"]654[/TD]
[TD="class: xl65"]No[/TD]
[/TR]
[TR]
[TD="class: xl66"]10-Nov[/TD]
[TD="class: xl65"]Julia[/TD]
[TD="class: xl65"]Red[/TD]
[TD="class: xl65"]125[/TD]
[TD="class: xl65"]Yes[/TD]
[/TR]
[TR]
[TD="class: xl66"]1-Dec[/TD]
[TD="class: xl65"]Betty[/TD]
[TD="class: xl65"]Purple[/TD]
[TD="class: xl65"]5558[/TD]
[TD="class: xl65"]No[/TD]
[/TR]
</tbody>[/TABLE]



Example B:


[TABLE="width: 429"]
<colgroup><col width="143" span="3" style="width:107pt"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 143"]Date[/TD]
[TD="class: xl67, width: 143"]Name[/TD]
[TD="class: xl67, width: 143"]Amount[/TD]
[/TR]
[TR]
[TD="class: xl66"]9-May[/TD]
[TD="class: xl65"]Mary[/TD]
[TD="class: xl65"]100[/TD]
[/TR]
[TR]
[TD="class: xl66"]5-Jun[/TD]
[TD="class: xl65"]John[/TD]
[TD="class: xl65"]54[/TD]
[/TR]
[TR]
[TD="class: xl66"]19-Jul[/TD]
[TD="class: xl65"]Paul[/TD]
[TD="class: xl65"]654[/TD]
[/TR]
</tbody>[/TABLE]



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