Hello,
Referring to my post HERE , I need help to extract dynamic range to copy another sheets within the same workbook based on below conditions.
1. every range have 3 rows blank inbetween after copying the first range.
2. Copy Data per year
2.1 Copy range based on year (Not knowing can be 2, 5 or more...). In sample file there are 2 years but it can be more years.
2.2 Copy only column A, Column D, Column E & Column F (Skip Columns B & C). This is for range copying per year only.
3. Copy top 15 Billers per year
3.1 Copy top 15 billers per year if possible sort in Descending order
3.2 Copy only column B, Column D, Column E & Column F (Skip Columns A & C). This is for top billers only
I appreciate if someone can help me.
Referring to my post HERE , I need help to extract dynamic range to copy another sheets within the same workbook based on below conditions.
1. every range have 3 rows blank inbetween after copying the first range.
2. Copy Data per year
2.1 Copy range based on year (Not knowing can be 2, 5 or more...). In sample file there are 2 years but it can be more years.
2.2 Copy only column A, Column D, Column E & Column F (Skip Columns B & C). This is for range copying per year only.
3. Copy top 15 Billers per year
3.1 Copy top 15 billers per year if possible sort in Descending order
3.2 Copy only column B, Column D, Column E & Column F (Skip Columns A & C). This is for top billers only
I appreciate if someone can help me.