Hi All,
I need help to figure out the code and to get the exact output.
I attached a workbook, what exactly i want here is macro first sort 2 columns (column A & column E) both A to Z then macro divide column A in 3 tabs based on below criteria
note: we have total 10 schemes and particular scheme has account name like below
liquid scheme include: LF
equity scheme include: EF & DF
debt scheme include: BF, CO, FF, MI, ST, TA, US
1) macro should divide column A in three tabs
2) then next macro should insert 3 blanks rows if column A value not same with above rows and 5 rows if column E value not same with above value
3) then next macro should give sum of column D based on column E
4) then next macro should give grand total of column D based on column A
i used a macro for rows inserting but i m unable to show total of each pay mode and grand total of scheme
What exactly output i need u can see in attached output file.
Please please Please anybody help me out with this its required me for payment funding.
I hope my explanation is understandable
Thanks in advance .
Bookmarks