hi im working for a compnay that requires me to generate reports on a monthly basis from raw files sent from the client. i was recently tasked to design a macro that is able to sort the data and put them in the right places which i have difficulty with im hoping someone here would be able to help me out.

so if u look at the attached file. in sheet 2 is a example of my raw data which i have to input into sheet 1 its pretty simple firstly i need to put redemption nominee account values into cash tab in sheet 1 for eg. sheet 2 c2 and d2 to be pasted into sheet 1 L3 and Q3 respectively. i could record a macro that copy paste whatever i do but as each month the amt of redemption and subscription varies how do i make it identify whether isit firstly a redemption or subscription then by the type whether isit CPFOA or SRS or Cash and input them into the right columns accordingly.