Tech Support Guy banner
Status
Not open for further replies.

Macro to identify contra entries and then preparing summary for same

788 views 0 replies 1 participant last post by  caavimak 
#1 ·
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

Example
Case I
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
Result would be Contra Entries, as similar shares in subs i.e. 10 is there in reds with amount also same.

Case II-
1. Subs Shares 10 Amount 100
2. Reds Shares -11 Amount 100
Result would be normal entry as shares are different.

Case III-
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
3. Subs Shares 10 Amount 100
Result would be Contra Entries for 1 and 2, as similar shares in subs i.e. 10 is there in reds with amount also same.
Result would be normal entry for 3 as I don't have any 4th entry for which shares and amount are same except for which sign would be different.

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
 

Attachments

See less See more
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top