First look for latest year in column B till the row end of serial number in column A. Here latest year is 2018-2019. I have to fetch last 3 years details in a seprate sheet product wise as mentioned in sheet "Target"
Since 2018-19 is the latest year, First copy and sum product-wise all the records of 2018-2019 on sheet Target table format in decending order as per amount.
then go the last record of the table and move four rows down and again similar way copy records of previous year to 2018-2019. Here previous year is 2017-2018. if there is no previous year then skip to next line
then go the last record of the table and move four rows down and again similar way copy records of previous year to 2017-2018. Here previous year is 2015-2016. There is no records for 2016-2017. if there is no previous year then skip to next line
Against all 3 teable I need to copy top-5 records. Here I need an option to change the number of top 5 records (From F to G) number changing option msg box is not required. I will change it from the code directly.. Means if I change the numer in code from 5 to 10 then top 10 records to be copied
Give Heading as "Top 5 Records" from F-H. If 10 records copied give heading as "Top 10 Records"
Then give sum in last row as given in row 10
Then need an code to do fe calclaultions as per the formula given in table on Shete Target
Also in Column U, I want add remarks as per the given concatenate formula
In concatenate, as per the number of rows, First highest, second highest, to be given
In concatenate, in last record instead of 1st, 2nd, mention last row.
Bookmarks