VBA macro to copy excel sheet result and rearranged and apply formula

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hi,


    The file: forum.ozgrid.com/index.php?attachment/69459/


    I need to do a few things to rearrange the data in the excel sheet so that it is easier to be processed and analysed.
    The actual output wanted as a sample is in sheet "Data_Result_Wanted"
    Attached is the excel sheet.


    • Loop to all the data in "data processing" and find the unique value in column A3 onwards and copy the unique value to a new sheet named "Data_Result_Wanted"
    • Copy the nominal and paste below the unique value of the data in a new sheet named "Data_Result_Wanted" This is the final output i need.
    • After that loop through column of actual value and copy the result below nominal.
    • Finishing that, then add some formula below to calculate the max,min,average and also std deviation.


    I have only managed to do part 1 to find the unique value via using macro recorder and filter the unit value but i have not rearranged the data yet in the result. This is in sub macro 3
    Also tried to rearranged the data using link from here and editing it but am not successful. the macro file is in sub Filter_Result


    Thanks in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!