+ Reply to Thread
Results 1 to 2 of 2

Need Help to insert rows based on multiple criteria in same column and give total and sbtl

  1. #1
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Need Help to insert rows based on multiple criteria in same column and give total and sbtl

    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 .
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Need Help to insert rows based on multiple criteria in same column and give total and

    Hi Masters,

    Any help please..................

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1