Hi Dave, it is me again! you provided a macro for me that would accumulate grocery expenses in a column with the cursor remaning in the cell for each entry. I would like to edit the macro but can't remember the name!! how can I see the list of macros without knowing its name? Thanks for your interest. ps the macro is called private sub worksheet_chankge(byval target as range) anton
On Thursday, 24 June 2010 09:54:30 UTC-4, Dave wrote: > Hi Anton, > Attached is a sheet with very simple code. Enter a value into a cell in > Column B, and you will see the adjacent cell in Col C increase by that > amount. Since this is done by VBA, there is no formula in the Col C cells, > so you can make manual corrections there if you want. You should note that > using this method gives you no record of past entries, since only the last > entry is retained in Col B cells. Previous entries are constantly > over-written > If you enter non-numeric data into Col B, the macro will fault. If this > sheet is just for personal use, then it doesn't really matter, but we could > test for non-numeric input if needed. > > Regards - Dave. > > > > Date: Thu, 24 Jun 2010 03:36:37 -0700 > > Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell > > From: a...@kwic.com <javascript:> > > To: excel-...@googlegroups.com <javascript:> > > > > Hi Dave, > > Thanks very much for your reply. Yes this would be sufficient. Your > > suggestion that XL can monitor changes to A2 and store the cumulative > > total in A3 would be great. I would have about 50 similar accounts > > such as gas, books, donations, repairs etc. > > Would you be able to construct this macro? > > Best Regards, > > anton > > > > > > On Jun 24, 1:49 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > > > Hi Anton, > > > > > > XL can almost do what you want, which may be sufficient for you. > > > > > > If you want to be able to enter your grocery expenditure always in the > same cell, XL can accumulate those entries in another cell using VBA. > > > > > > For example, You may enter your grocery expenditure always into A2, > but the actual accumulated total would appear in A3 (or any other cell you > like). This can be done by clicking a button after each entry into A2, or > XL can monitor changes to A2 and do the accumulation automatically. > > > > > > If this suits your purpose, there are lots of us in the group who > could help you achieve this. > > > > > > Regards - Dave. > > > > > > > > > > > > > > > > > > > Date: Wed, 23 Jun 2010 11:22:58 -0700 > > > > Subject: $$Excel-Macros$$ how to get cumulative sum in a cell > > > > From: a...@kwic.com > > > > To: excel-...@googlegroups.com <javascript:> > > > > > > > Dear Group, > > > > I am constructing a single entry accounting spreadsheet in excel. i > > > > would like to input numbers for, say grocery expenses, in a cell of > > > > fixed location. when I buy more groceries i would like to type in the > > > > new expense in the same cell so that the output of that cell is the > > > > cumulative total expenses for groceries. > > > > any way to do this in excel? > > > > Thanks for reading, > > > > anton > > > > > > > -- > > > > > ---------------------------------------------------------------------------------- > > > > 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 athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > > > To post to this group, send email to > > > > excel-...@googlegroups.com<javascript:> > > > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > HELP US GROW !! > > > > > > > We reach over 7000 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group athttp:// > groups.google.com/group/excel-macros/subscribe > > > > > > _________________________________________________________________ > > > Need a new place to live? Find it on Domain.com.auhttp:// > clk.atdmt.com/NMN/go/157631292/direct/01/- Hide quoted text - > > > > > > - Show quoted text - > > > > -- > > > ---------------------------------------------------------------------------------- > > 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-...@googlegroups.com<javascript:> > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 7000 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > ------------------------------ > Meet local singles online. Browse profiles for > FREE!<http://clk.atdmt.com/NMN/go/150855801/direct/01/> > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
