Hi everyone,

I am new in using macro and I am very interested and having so much fun in using it. However as I am new to it I still have limited knowledge in this. I have my first big assignment and my problem is how to filter and extract to another sheet. (e.g sheet1 to sheet2 ), getting the max and min number, and also getting the total records of all data and the total of the filtered data.

I will be attaching a file and recorded a macro on it to show how the process would be like. Your knowledge will be a very big help and big step for me. Thank you

MasterList1.xlsm