Hi Sudhir, Check if its working. I have done it for only "Running Balance". I am not clear with the " Pending Amount" the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code.
Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar <bluecore...@gmail.com>wrote: > Hi > > Running balance mean's outstanding of Parties on left side display date. > Pending amount mean's pending bills upto outstanding. > > thanx > > > > > On 19 March 2011 05:27, Umesh Dev <umesh.d...@gmail.com> wrote: > >> Hi Sudhir, >> >> It is still not clear, how to get the Running Bal and the Pending Amount. >> >> >> Regards >> Umesh >> >> >> On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar <bluecore...@gmail.com>wrote: >> >>> Dear Experts, >>> >>> >>> Please read my attachment and solve it. >>> >>> thanx >>> >>> >>> >>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> >>> Sudhir Verma >>> Asstt. Mngr. A/c's >>> 9818479722 >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9818479722 > * > P think Before you print > * > * > ** > Life is Very beautiful !!! > * > * > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´. > * > * > * > *Happy **Valentine** Day * > \ ¦ / > (ò ó) > _____ ___o0o___(_)___o0o__ > ___¦_____¦_____¦_____¦_____¦ > ¦_____¦_____¦_____¦_____¦__ > ___¦_____¦_____¦_____¦_____¦ > *Drink Bear Save Water* > * > * > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Day Book-1.xlsm
Description: Binary data
