Hi Sudhir, In the excel sheet which you have send me, for the party name "b" on 14th March you have mentioned 1700 as the pending amount. My question is How do you come to arrive at this figure? 1700
Regards Umesh On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar <bluecore...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
