Hi, Thanx and It's feel good to see done with macro. And how to copy it to my main workbook.
Meaning of Pending Amount : It mean's payment which was not collected yet. Regards Sudhir On 21/03/2011, Umesh Dev <umesh.d...@gmail.com> wrote: > 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 > -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> 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
