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
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.
Last edited by caavimak; 10-05-2012 at 03:25 PM.
Re: Macro to identify contra entries and then preparing summary for same
Can somebody please help me
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1