+ Reply to Thread
Results 1 to 2 of 2

Macro to identify contra entries and then preparing summary for same

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Pune, India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Macro to identify contra entries and then preparing summary for same

    I have a sheet with name "Ole data" in which there are details of subs i.e. subscription and reds i.e. redemption

    Now, I want to first identify what are contra entries and what are normal entries

    Contra entries means
    Where
    subs (amount) +reds (amount)=0 and subs (shares) + reds (shares)=0

    Once I have identifies above, I want summary of above transactions in "Summary" tab.

    There is no specific number of rows i.e. rows can be at a time 10 or it 1000 also.

    Sheet is attached for your reference.
    Attached Files Attached Files
    Last edited by caavimak; 10-05-2012 at 03:25 PM.

  2. #2
    Registered User
    Join Date
    09-08-2012
    Location
    Pune, India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Macro to identify contra entries and then preparing summary for same

    Can somebody please help me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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