Trend analysis worksheet automatic completion from variable number of rows on data sheet

Good morning,

I have a sawing log at work that I enter data for on a daily basis. Each time the blade is changed I then complete a trend analysis page to enable comparison of the usefulness of the blades. The number of cuts that a blade achieves is changeable so the number of rows that each blade spans on the data sheet is also variable. Each blade has a single line on the analysis sheet.

What I want to do is to be able to complete a row on the data sheet for each cut and for it to automatically append the relevant data to the analysis sheet.

I can supply more detail to give context if requested but I am so novice on Excel that I don't want to lead the thread in any particular direction as I cannot envisage what the possible solutions might be.

Thanks for any suggestions that you can bring to me :-)

Thanks anyway. I solved my own problem. It was as simple as using SUMIF and AVERAGEIF and adding a hidden column with the blade identifier into my data sheet.

Peace out for the 15.